Replication is an important and powerful technology for distributing data and the execution of 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.
| Topic | Description |
|---|---|
| Design Requirements for Replication | Describes how SQL Server replication technology provides different benefits and requirements, depending on your requirements for transactional consistency and site autonomy, and your ability to partition data. |
| Replication Model | Describes the replication model. The replication model consists of Publishers, Distributors, and Subscribers, articles and publications, and push and pull subscriptions. |
| Planning for Replication | Discusses the importance of careful planning for replication to minimize the demands on network resources and maximize data consistency. |
| Managing Replication Security | Describes the built-in security features which help you protect your data and application, including role requirements for performing replication actions, publication access lists to restrict logins, and the ability to set passwords on Distributors. |
| Configuring Replication | Describes how you can use replication wizards, SQL-DMO, or Transact-SQL stored procedures to configure replication, including enabling, modifying, or disabling servers as Publishers, Subscribers, or Distributors. |
| Publishing Data and Stored Procedures | Describes how data is published by creating a publication, selecting the tables or stored procedures to be included in the publication, and making the publication available to Subscribers. |
| Subscribing to Publications | Describes how a destination database on a Subscriber subscribes to replicated data from a publication database on a Publisher. |
| Reporting and Resolving Conflicts | Discusses reporting and resolving conflicts. The conflict resolver determines the “winner” and “loser” when conflicts occur during the merge process, and you can use the Replication Conflict Viewer to review and modify the outcome. |
| Monitoring Replication | Describes how to use Replication Monitor, a component of SQL Server Enterprise Manager that allows you to monitor agent performance, data validity, and replication alerts. |
| Enhancing Performance | Describes a variety of actions you can take for each type of replication to improve your application’s performance. |
| Advanced Replication | Describes the ways in which tasks such as backing up and restoring databases, publishing on the Internet, and replicating data to and from heterogeneous data sources may be important for your application. |