Oracle to DB2 data migration
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.