Synchronize Subscriptions (Replication)

Subscriptions are synchronized by replication agents. The Distribution Agent synchronizes subscriptions to transactional and snapshot publications, and the Merge Agent synchronizes subscriptions to merge publications. You can use SQL Server Management Studio, replication stored procedures, and Replication Management Objects (RMO) to synchronize subscriptions and to control synchronization behavior. The following topics describe how synchronize subscriptions and specify synchronization options.

In This Section

• Create and Apply the Initial Snapshot

• Create a Snapshot for a Merge Publication with Parameterized Filters

• Enable Initialization with a Backup for Transactional Publications (SQL Server Management Studio)

• Initialize a Transactional Subscription from a Backup (Replication Transact-SQL Programming)

• Initialize a Subscription Manually

• Synchronize a Pull Subscription

• Synchronize a Push Subscription

• Reinitialize a Subscription

• Execute Scripts Before and After a Snapshot Is Applied (SQL Server Management Studio)

• Execute Scripts During Synchronization (Replication Transact-SQL Programming)

• View and Resolve Data Conflicts for Merge Publications (SQL Server Management Studio)

• View Data Conflicts for Transactional Publications (SQL Server Management Studio)

• Synchronize a Subscription Using Windows Synchronization Manager (Windows Synchronization Manager)

• Implement a Business Logic Handler for a Merge Article

• Debug a Business Logic Handler (Replication Programming)

• Control the Behavior of Triggers and Constraints During Synchronization (Replication Transact-SQL Programming)

• Implement a Custom Conflict Resolver for a Merge Article

See Also

Concepts

Synchronize Data