Replication and Heterogeneous Data Sources

SQL Replication


Replication and Heterogeneous Data Sources

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 OLE DB or ODBC and creating a push subscription from the Publisher to the OLE DB or ODBC Subscriber.

SQL Server 2000 supports replication between different versions of SQL Server and it supports replication to Subscribers running Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE). For more information, see Replication Between Different Versions of SQL Server and Replication with SQL Server for Windows CE.

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.