Post reply

Raima Database Data Import

  • July 4, 2008 at 4:20 pm

    #154502

    Have many old raima database that i need to import into SQL databases for review. How can this be done? does anyone have that experience?

  • July 4, 2008 at 9:07 pm

    #838458

    What is a "Raima" database? Never heard that one before...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • July 4, 2008 at 9:11 pm

    #838461

    Raima Data Manager Version 3.30, a very old technology, company is now overseas, and looking for a way to import data from databases. Believe it or not, it is still in use today all over the US, but was written around the windows 95 era, and when used on 2000 or XP it crashes alot. Thus the reason to pull data and use on current DB product.

  • July 4, 2008 at 10:08 pm

    #838465

    I don't believe there's anything in SQL Server that will import such a thing... does it have any export capabilities, say, to a CSV or fixed field text file?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • July 5, 2008 at 7:37 am

    #838499

    Visit their web site for a free SDK (apparently uses C or C++) and you might be able to generate a CSV per Jeff's suggestion and then import from that. The article mentions ODBC capabilities for what it would be worth for your solution

    http://www.linuxdevices.com/news/NS8794867415.html

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • July 7, 2008 at 5:57 pm

    #839230

    no utilites available, custom program. Looking for something to look into the old version database. Greg

  • July 7, 2008 at 6:52 pm

    #839238

    Did you look into the SDK offered as a free download?

    It could give you sufficient information so as to be able to write a program using a flavor of C code to extract the data and write same to a delimited file to be imported into a version of SQL Server.

    I have one nagging thought in the back of my mind, was this custom application purchased and if so what copy rights did your company agree to intentionally or un-intentionally when purchasing?

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • July 7, 2008 at 9:42 pm

    #839250

    Automated Logic Corporation. Its so old for them, they have no info, and dont even have anyone around whom know how it works. Product is TWO complete versions of application product and about 10 versions old. Problem is its in about 30 customer sites who are haveing a devil of a time because it fails repeatedly when used with anything newer than windows 98. We use it on W2000, but have MANY problems, and i need a solution to migrate the saved data that exists. Thanks, Greg

  • July 9, 2008 at 7:27 am

    #840115

    Oh, my! I last saw a Raima database in 1996. Brr! Cold!

  • July 9, 2008 at 7:56 am

    #840162

    Raima Corp - used to be dbVista. Object-oriented database server. I had supported banking system on that platform. It was very good experience because the team was exceptional. Now it is Velosis Database Server.

    Per question: this database manager was build using C/C++ libraries and should have very powerful API. You need normal C/C++ developer and the file that contains schema of the database to get data from it if you do not have report builder in that system (I had had thus I had never had any problems). It would be a huge problem if you do not have schema. As far as I am recalling – it is almost impossible to rebuild data without database schema even if you know what is there. However, they had and they have ODBC driver that should give you direct connection using SSIS in MS SQL 2005 to Raima. But I have never used it thus I am talking about developer. API is free base on info from: http://www.birdstep.com/database/Products/RDM-Server/SDK-Download/

    I had known one of the guys that should be working in headquarter of the company but it was almost decade ago. Feel free to contact me if it is helpful and you think I can provide any help.

    Alex Prusakov

  • August 11, 2008 at 3:42 am

    #855944

    Just thinking laterally as a stop-gap measure. Perhaps you can use VMWare to run Windows 95 as a guest OS, so you can continue to run the old software under the original designed OS, but on new hardware.

  • August 11, 2008 at 8:30 am

    #856112

    Thats a good thought, but the DB does not function correctly, and i need to extract the data. Thanks.

  • August 11, 2008 at 7:04 pm

    #856439

    I came across the following page in my own search for a method of extacting RDM 3.3 data. My conversion need is not critical enough to pay for (its more a hobby at the moment to develop some support tools for old PLC programming software) but this guy looks like he might have the experience you need. I'd be interested in what you end up finding.

    http://www.rogergough.com/implus/implus.html

  • August 11, 2008 at 7:19 pm

    #856447

    You may be interested in the Release Notes showing database compatability with old RDM versions.

    http://docs.raima.com/rdme/8_1/Content/GS/RelNotes.htm?SearchType=Stem&Highlight=Compatibility|compatible|compatibility

  • January 8, 2009 at 5:48 am

    #923228

    Did Greg ever manage to get this resolved? I am about to embark on exactly the same journey.

    Dan

Viewing 15 posts - 1 through 15 (of 21 total)

You must be logged in to reply to this topic. Login to reply