Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Raima Database Data Import Expand / Collapse
Author
Message
Posted Friday, July 4, 2008 4:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 23, 2009 12:44 PM
Points: 6, Visits: 14
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?
Post #528777
Posted Friday, July 4, 2008 9:07 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 10:52 PM
Points: 37,056, Visits: 31,619
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #528787
Posted Friday, July 4, 2008 9:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 23, 2009 12:44 PM
Points: 6, Visits: 14
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.
Post #528790
Posted Friday, July 4, 2008 10:08 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 10:52 PM
Points: 37,056, Visits: 31,619
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #528794
Posted Saturday, July 5, 2008 7:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:41 PM
Points: 5,613, Visits: 25,165
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

Before posting a performance problem please read
Post #528838
Posted Monday, July 7, 2008 5:57 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 23, 2009 12:44 PM
Points: 6, Visits: 14
no utilites available, custom program. Looking for something to look into the old version database. Greg
Post #529710
Posted Monday, July 7, 2008 6:52 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:41 PM
Points: 5,613, Visits: 25,165
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

Before posting a performance problem please read
Post #529722
Posted Monday, July 7, 2008 9:42 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 23, 2009 12:44 PM
Points: 6, Visits: 14
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
Post #529736
Posted Wednesday, July 9, 2008 7:27 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, November 4, 2013 4:22 PM
Points: 480, Visits: 467
Oh, my! I last saw a Raima database in 1996. Brr! Cold!
Post #530779
Posted Wednesday, July 9, 2008 7:56 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, August 8, 2014 7:43 AM
Points: 92, Visits: 221
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
Post #530826
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse