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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.