Replication is an important technology for distributing data and stored procedures across an enterprise. The replication technology in Microsoft® SQL Server™ allows you to make duplicate copies of your data, move those copies to different locations, and synchronize the data automatically so that all copies have the same data values. Replication can be implemented between databases on the same server or different servers connected by LANs, WANs, or the Internet.
The replication model used in SQL Server continues to build on the publish and subscribe metaphor introduced by earlier versions of SQL Server. SQL Server also supports:
| Implementing Snapshot or Transactional Replication to Heterogeneous Data Sources | Monitoring Replication Agents |
| Implementing Replication from Heterogeneous Data Sources |