Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I want to transfer data from an old DB2 system to a new Oracle database.

How should I go about doing this?

share|improve this question

migrated from stackoverflow.com May 6 '13 at 20:16

This question came from our site for professional and enthusiast programmers.

3 Answers 3

Another approach is to use the Oracle Gateway for DB2 which can be used to create an Oracle database link to the DB2 database. Then use a SQL script to "pull" all the data from each table in turn by

insert into oracle_table select * from db2_table@dblink;
share|improve this answer

You export the data from Db2 and import into Oracle. There are considerations such as big-Endian, Unix vs Windows etc.

Here is a link:

http://www.ibm.com/developerworks/data/library/techarticle/dm-0505tham/

share|improve this answer

There's a dedicated migration tool that should meet your needs:

http://www.oracle.com/technetwork/database/migration/db2-084087.html

Another common solution to migrate data is export each table in a CSV file and then import each CSV file in the new database tables. To import CSV into Oracle tables you can use the Sql Loader utility (that comes with Oracle), with this useful tool to automatically create the script needed.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.