Replication and Heterogeneous Data Sources (Enterprise Manager)

Microsoft® SQL Server™ 2000 offers the ability to replicate data to any heterogeneous data source that provides a 32-bit ODBC or OLE DB driver on Microsoft Windows® 2000, Microsoft Windows NT® Server 4.0, or Windows 98 operating systems. Additionally, SQL Server 2000 can receive copies of data replicated from Microsoft Access, Microsoft Exchange, Oracle, DB2 Universal, DB2/MVS, and DB2 AS400.

Heterogeneous Subscribers

Publishing to heterogeneous data sources allows corporations that have acquired different databases to continue providing SQL Server 2000 to individuals or offices using those databases.

The simplest way to publish data to a heterogeneous data source is by using ODBC and creating a push subscription from the Publisher to the ODBC Subscriber.

Heterogeneous Publishers

SQL Server 2000 can subscribe to snapshot or transactional data replicated from Oracle, DB2, Access, and other data sources. This allows companies that are planning to deploy large databases or a data warehouse with SQL Server, or Internet and intranet applications, to gain access to various sources of data. That data can then be consolidated in SQL Server 2000 using replication, and placed into a data mart, data warehouse, or multidimensional database designed for SQL Server Analysis Services.

To implement snapshot or transactional replication published by heterogeneous data sources to your SQL Server 2000 applications, configure SQL Server with third-party software or using applications built with SQL-DMO and the Replication Distributor Interface.

For more information, see Programming Replication from Heterogeneous Data Sources.