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
Data migration puzzle
Moderators: chulett, rschirm, roy
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>