sql server replication: Replication with DB-2 on AS/400 -- sql server replication

Replication with DB-2 on AS/400

JI
8/7/2003 7:30:18 AM

sql server replication: What is the best way to replicate data with heteorgenous
source? I need data to be capable of updating on both
servers. Here is the layout.

One SQL2k box, One DB/2 box.

do i use merge?
transactional with updates?
two phased commits?

Re: Replication with DB-2 on AS/400

Deepak kumar [MSFT]
8/8/2003 3:45:08 PM

SQL server offers DB2 subscriber using ODBC or OLEDB out of the box. But
publishing directly from DB2 to SQL server will need some development work.
You can read SQL server BOL for Heterogenous data source.

Your choice of the kind of replication will depend upon your performance
need and the cost of development effort.

Thanks!

[quoted text, click to view]