Replication in Heterogeneous Environments

SQL Server 2008 allows for transactional and snapshot replication of data into and out of environments other than SQL Server. This is termed heterogeneous replication. The easiest way to set up this replication is to use ODBC or OLE DB and create a push subscription to the subscriber. This is much easier to make work than you might imagine. SQL Server can publish to the following database types:

• Microsoft Access

• Oracle

• Sybase

• IBM DB2/AS400

• IBM DB2/MVS

SQL Server can replicate data to any other type of database, provided that the following are true:

• The driver must be ODBC Level 1 compliant.

• The driver must be 32-bit, thread safe, and designed for the processor architecture on which the ...

Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.