Synchronizing Subscriptions (Replication)

SQL Server 2008 Books Online (October 2009)

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

How to: Create and Apply the Initial Snapshot (SQL Server Management Studio)
How to: Create the Initial Snapshot (Replication Transact-SQL Programming)
How to: Create the Initial Snapshot (RMO Programming)
How to: Create a Snapshot for a Merge Publication with Parameterized Filters (SQL Server Management Studio)
How to: Create a Snapshot for a Merge Publication with Parameterized Filters (Replication Transact-SQL Programming)
How to: Create a Snapshot for a Merge Publication with Parameterized Filters (RMO Programming)
How to: Enable Initialization with a Backup for Transactional Publications (SQL Server Management Studio)
How to: Initialize a Transactional Subscription from a Backup (Replication Transact-SQL Programming)
How to: Initialize a Subscription Manually (SQL Server Management Studio)
How to: Initialize a Subscription Manually (Replication Transact-SQL Programming)
How to: Synchronize a Pull Subscription (SQL Server Management Studio)
How to: Synchronize a Pull Subscription (Replication Programming)
How to: Synchronize a Pull Subscription (RMO Programming)
How to: Synchronize a Push Subscription (SQL Server Management Studio)
How to: Synchronize a Push Subscription (Replication Programming)
How to: Synchronize a Push Subscription (RMO Programming)
How to: Reinitialize a Subscription (SQL Server Management Studio)
How to: Reinitialize a Subscription (Replication Transact-SQL Programming)
How to: Reinitialize a Subscription (RMO Programming)
How to: Execute Scripts Before and After a Snapshot Is Applied (SQL Server Management Studio)
How to: Execute Scripts During Synchronization (Replication Transact-SQL Programming)
How to: View and Resolve Data Conflicts for Merge Publications (SQL Server Management Studio)
How to: View Data Conflicts for Transactional Publications (SQL Server Management Studio)
How to: Synchronize a Subscription Using Windows Synchronization Manager (Windows Synchronization Manager)
How to: Implement a Business Logic Handler for a Merge Article (Replication Programming)
How to: Implement a Business Logic Handler for a Merge Article (RMO Programming)
How to: Debug a Business Logic Handler (Replication Programming)
How to: Control the Behavior of Triggers and Constraints During Synchronization (Replication Transact-SQL Programming)
How to: Implement a COM-Based Custom Conflict Resolver for a Merge Article (Replication Programming)
How to: Implement a Stored Procedure-Based Custom Conflict Resolver for a Merge Article (Replication Transact-SQL Programming)

Concepts

Synchronizing Data

Help and Information

Getting SQL Server 2008 Assistance