Wednesday, March 7, 2012

Replication - DB2 as publisher - SQL 2005 as subscriber

I have been looking for a way to replicate data from a DB2 system running on an AIX machine. I found some information related to doing this with SQL2000, but not with 2005. Can this be done - preferably without writing our own provider.

Thanks in advance

I have the same problem. I am trying to replicate data from DB2/AS400 to SQL Server 2005. I am able to connect to DB2 through SQL Analyzer and can query DB2 tables but I don’t know how to replicate data. I have done my research and people told me that it can’t be done but couldn’t find any article or book (I also went to book store) which could tell me the way how to do it. If you find any thing please post it here.

Thanks

|||You have to use something like Data Mirror for this or code your own solution.|||But then what about Heterogeneous Replication. Is it just for Oracle to and from SQL Server?

No comments:

Post a Comment