Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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