Implementing Replication
This section provides information about the stages involved in implementing replication. For an overview, see Implementing Replication Overview. The five stages of implementing replication are:
| Stage | Tasks |
|---|---|
Describes identifying and configuring the Distributor and Publisher. |
|
Describes creating a publication and defining the data and database objects in the publication, setting options, and applying filters, if necessary. |
|
Describes creating push and pull subscriptions; and how to specify synchronization schedules and set other options. |
|
Describes how to initialize the Subscriber. |
|
Describes how to specify options for synchronization, which occurs when the Distribution Agent or Merge Agent runs and updates are propagated between the Publisher and Subscribers. |
The section also includes information on: implementation considerations; methods of implementing replication; scripting replication; removing replication; heterogeneous replication; replicating data to other versions of Microsoft SQL Server; and replicating data over the Internet:
- Implementation Considerations for Replication
- Methods of Implementing Replication
- Scripting Replication
- Removing Replication
- Non-SQL Server Publishers
- Non-SQL Server Subscribers
- Replicating Data to SQL Server Compact Edition
- Replicating Data to SQL Server Express
- Implementing Replication over the Internet
For more information about common replication scenarios, see Replicating Data in a Server to Server Environment and Replicating Data Between a Server and Clients.
See Also
Other Resources
Configuring and Maintaining Replication