Discussion

1
Replies
252
Views
Close popover
Chandra Andhe (chandu231)

CA
chandu231 Member since 2014 1 post
Posted: April 30, 2016
Last activity: June 30, 2016
Closed

Oracle to DB2 data migration

Hi All,

We are trying to move data from an Oracle Database to DB2 for an existing application. We would like to copy over the Cases and Custom data. 

Custom data migration is easy since it does not have any BLOB fields. THe issues is when the BLOB fields come into play.

These are the couple of questions I have:

1) Can I copy all the tables using a .sql insert script from Oracle and run it on DB2? Will this help me retrieve all the Old Cases?

2) Is there any difference in the content of the BLOB field when it is saved in Oracle vs DB2?

3) Any better tools that can aid in the migration of the data.

Any help is greatly appreciated.

Thanks,

Chandu

Data Integration
Moderation Team has archived post