Discussion

1
Replies
259
Views
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.