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
- Replicating Data in a Server to Server Environment
Explore scenarios that involve replicating data between servers.
- Replicating Data Between a Server and Clients
Explore scenarios that involve replicating data between servers and clients, including workstations, laptops, tablets, and devices.
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
- Administering Replication
Find detailed information here on monitoring replication, replication agents, enhancing replication performance, backing up and restoring replicated databases, and upgrading replicated databases.
- Frequently Asked Questions for Replication Administrators
Find information about frequently asked questions, covering areas such as configuring replication, logins and object ownership, database maintenance, and replication maintenance.
- Best Practices for Replication Administration
Find best practices information, covering areas such as backup and restore, scripting, setting thresholds and alerts, monitoring, and establishing performance baselines.
Programming
- Programming Replication Using System Stored Procedures
Learn to program using system stored procedures, which provide access to all of the user-configurable functionality in a replication topology.
- 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.
- Programming Replication Agent Executables
Learn to program using replication agents, which carry out the tasks associated with tracking changes and distributing data.
- Replication Programming Samples
Replication includes sample applications that demonstrate how to programmatically access replication functionality.