470,641 Members | 1,622 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,641 developers. It's quick & easy.

Copy data between databases

2
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
Nov 29 '06 #1
0 1860

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by lgbjr | last post: by
2 posts views Thread by Pascal Polleunus | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.