Web Development

Ask something
Discussion Locked

Data Move between Oracle and non-ODBC DB

0 helpful
5 replies

by bytj 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a database running in Oracle8i. I need to move some data from this Oracle DB to a non-ODBC compliant database. I wonder how I can approach to this issue.

Thanks.

5 replies

by timthetoolman

Hi,

This almost certainly isn't the best way, but it is *a* way if nobody else answers you...

For each table write a query to extract all the data to a text file. Each Row extracted should be manipulated to produce an equivalent sql insert statement... I cant remember whether Oracle has the ability to automatically generate these scripts or not...

For example if the table contained Name, age, sex, address... then from this you would conceptually generate...

insert (name, age, sex, address) into NewTable values ('', '', '', '')

Then you can run the generated SQL to populate the DB.

This will only work if there isn't mountains of data. Otherwise it'll be too slow and costly.

Cheers,
Tim.

by avihs

The Tool for Oracle Application Developers (TOAD) offers these kind of utilities. If you have this tool you can do it easily.
The other approach is you may need to write an application in VB or an equivalent tool.

This discussion is closed to new replies.