O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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).

NOTE

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required