Hi,
I would like a utility that will allow me to transfer data between two DB2 databases. These are both on the same server.
They have slightly different fields etc so the transfer method should allow mapping between fields.
It is just the data I want to move not schemas etc. I have looked at DB2MOVE but as the databases use foreign keys, so it does not work.
The alternative is, can anybody assist me to list off and save foreign keys, then remove same. transfer data with DB2MOVE then re-instate foreign keys on the new database?
All this would need to be done with no changes to source database.
I have some 20-30 database that need migrating (For the top level application's needs)
Many Thanks
Mark