Implementing Replication from Heterogeneous Data Sources

Microsoft® SQL Server™ provides a programming framework that enables heterogeneous data sources to become Publishers within the SQL Server replication framework.

By integrating with SQL Server replication, heterogeneous applications can inherit a full set of replication features, such as:

• Remote store-and-forward databases and Distribution Agents.
• Heterogeneous Subscribers, including Microsoft Access, Oracle, and DB2.
• Pull subscriptions.
• Anonymous subscriptions.
• Internet subscriptions.
• Subscriptions on computers running Microsoft Windows® 95/98.
• Stand-alone and embeddable Distribution Agents.
• Monitoring and troubleshooting tools using SQL Server Enterprise Manager.
• Replication agent scheduling using SQL Server Agent.
• Alerts and notifications.
• Performance monitoring.

The programming framework for transactional and snapshot replication from heterogeneous data sources includes:

• Programmable SQL-DMO replication objects for administering and monitoring replication.
• The Replication Distributor interface for storing replicated transactions from a heterogeneous Publisher.
• A Distribution Agent to forward the transactions to Subscribers.
• SQL Server Enterprise Manager to administer and monitor replication graphically.

Using Data Transformation Services (DTS), heterogeneous data sources can be used to create snapshot replication publications.

See Also

Programming Transactional and Snapshot Replication from Heterogeneous Data Sources