How to Implement Bi-Directional Replication from DB2 to SQL Server

Question

How we need to implement Raplication from DB2 to SQL Server and SQL to DB2 .

Answer 1

SQL Server 2008 supports the following heterogeneous scenarios for transactional and snapshot replication: so you cannot use SQL Server replication feature to achieve this

• Publishing data from Oracle to SQL Server.

• Publishing data from SQL Server to non-SQL Server Subscribers SQL Server

http://msdn.microsoft.com/en-us/library/ms151149(v=sql.105).aspx

You can look into options like developing your own solution using SSIS or linked servers

Answer 2

Hi,

I might be mistaken but I don't think there is a solution from Microsoft for replication with DB2. There are some third party products out there but I have not tested them in full. Look at DBMoto, Attunity and IBM.

Shouldn't this question be posted in 'SQL server replication' category instead of under security ?

Thong