SQL Server Replication (How Do I)

Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.

The following list of key topics will help you learn more about how to install, understand, and use replication.

Orientation and Setup

  • Replication Publishing Model Overview
    Replication uses a publishing metaphor that represents the components of replication technology, including Publishers, Distributors, Subscribers, publications, articles, and subscriptions. Gain an understanding of these concepts here.
  • Types of Replication Overview
    SQL Server offers three types of replication, snapshot, transactional, and merge, each suited to different application requirements. Learn about each type of replication and how to decide which types best fit your application.

Designing and Creating

Deploying and Testing

  • Implementing Replication
    Learn the ways in which you can implement replication and the stages involved in implementing replication, including information on heterogeneous replication and replicating data over the Internet.
  • Security Considerations for Replication
    It is important to understand how to secure a replication environment to protect the data and business logic in your application. This section describes replication security features.
  • Monitoring Replication
    Monitoring a replication topology is an important aspect of deploying replication. Because replication activity is distributed, it is essential that an administrator track activity and status across all computers involved in replication. This section describes how, using Replication Monitor, SQL Server Management Studio, and System Monitor.


  • Administering Replication
    Find detailed information here on monitoring replication, replication agents, enhancing replication performance, backing up and restoring replicated databases, and upgrading replicated databases.


  • Programming with Replication Management Objects
    Learn to program using Replication Management Objects (RMO). RMO is a managed code assembly that encapsulates replication configuration, administration, and synchronization functionality.

See Also

Other Resources

SQL Server Replication

Help and Information

Getting SQL Server 2005 Assistance