Designing and 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
Configuring Distribution	Describes identifying and configuring the Distributor and Publisher.
Publishing Data and Database Objects	Describes creating a publication and defining the data and database objects in the publication, setting options, and applying filters, if necessary.
Subscribing to Publications	Describes creating push and pull subscriptions; and how to specify synchronization schedules and set other options.
Initializing a Subscription	Describes how to initialize the Subscriber.
Synchronizing Data	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:

• Solution Design Considerations (Replication)

• Methods of Implementing Replication

• Scripting Replication

• Removing Replication

• Non-SQL Server Publishers

• Non-SQL Server Subscribers

• Replicating Data to SQL Server Compact

• 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

Concepts

Development (Replication)