Adding NonSQL Server (Heterogeneous) Subscribers

SQL Server can replicate to nonSQL Server ODBC or OLE DB subscribers such as Microsoft Access and Oracle databases. As stated earlier, nonSQL Server ODBC sources can only be subscribers. You can use transactional and snapshot replication with all heterogeneous subscribers, merge replication with Microsoft Access subscribers, and immediate update subscribers with SQL Server. ODBC or OLE DB subscribers can be publishers using third-party software (which might or might not be available for your particular data source).


Because nonSQL Server subscribers use ODBC or OLE DB, the list of possible nonSQL Server subscribers will increase. For an updated list of supported heterogeneous subscribers, ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition 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.