SQL Server Performance Forum – Threads Archive
Replicating from IBM DB2 to sql serverHello everyone, I have to replicate data from IBM DB2 on AS/400 mainframe to SQL server2000. I am not permitted to make any changes in IBM DB2 code. I have full access rights and permissions for the specific data tables. Is there any way i can replicate the tables from IBM DB2 to SQL server 2000 using development tools and/or DTS to do that? regards,
Did you solve this problem? I am interested to know that [<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
Well, since the data transfer in my application is bi-directional, i probably have to rely on third party software like Datamirror for full replication and data exchange. There’s another way by defining the DB2 as linked server in SQL server. I am investigating that option, still not sure whether it will suite the needs. If you have some insights then do share please. Thank you.