Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Raima Database Data Import


Raima Database Data Import

Author
Message
Greg Brunacci
Greg Brunacci
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
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?
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)

Group: General Forum Members
Points: 53186 Visits: 40377
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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Greg Brunacci
Greg Brunacci
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
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.
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)

Group: General Forum Members
Points: 53186 Visits: 40377
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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
bitbucket-25253
bitbucket-25253
SSCertifiable
SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)

Group: General Forum Members
Points: 6267 Visits: 25280
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
Greg Brunacci
Greg Brunacci
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 14
no utilites available, custom program. Looking for something to look into the old version database. Greg
bitbucket-25253
bitbucket-25253
SSCertifiable
SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)

Group: General Forum Members
Points: 6267 Visits: 25280
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
Greg Brunacci
Greg Brunacci
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
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
Kent Waldrop
Kent Waldrop
SSC-Addicted
SSC-Addicted (498 reputation)SSC-Addicted (498 reputation)SSC-Addicted (498 reputation)SSC-Addicted (498 reputation)SSC-Addicted (498 reputation)SSC-Addicted (498 reputation)SSC-Addicted (498 reputation)SSC-Addicted (498 reputation)

Group: General Forum Members
Points: 498 Visits: 467
Oh, my! I last saw a Raima database in 1996. Brr! Cold!
Alex Prusakov
Alex Prusakov
SSC-Enthusiastic
SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)

Group: General Forum Members
Points: 104 Visits: 301
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search