Data migration puzzle

ajith · Post by **ajith** » Mon Sep 25, 2006 6:21 am

Hi All
I am having some 500 tables in DB2 with considerable amount of data. (Assume all tables have at least 50000 records)

I want to migrate the all the tables to SQL server.

If we go for data migration project in Datastage parallel edition, we have to create 500 jobs. Do we have any better options?

Thank you
Ajith

ArndW · Post by **ArndW** » Mon Sep 25, 2006 6:37 am

If you are doing mainly a 1 table to 1 table migration with identical columns then you can create generic PX jobs to do this for you using what is called "runtime column propagation" and won't need to create that many jobs.

kumar_s · Post by **kumar_s** » Mon Sep 25, 2006 6:38 am

Though you can load more than one table in a single job, it is suggested to split it. It is better to have many module. You can optionally group it based on some master tables and its child tables to gether.

kduke · Post by **kduke** » Mon Sep 25, 2006 7:52 am

Look at viewtopic.php?t=103074