Discussion

1
Replies
245
Views
chandu231 Member since 2014 1 post
Posted: 4 years ago
Last activity: 4 years 3 months ago
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
Share this page LinkedIn