Synchronizing Subscriptions (Replication Transact-SQL Programming)
SQL Server 2005
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.
The following topics describe how to programmatically synchronize subscriptions and control synchronization behaviors:
-
How to: Create the Initial Snapshot (Replication Transact-SQL Programming)
-
How to: Create a Snapshot for a Merge Publication with Parameterized Filters (Replication Transact-SQL Programming)
-
How to: Synchronize a Pull Subscription (Replication Programming)
-
How to: Synchronize a Push Subscription (Replication Programming)
-
How to: Initialize a Transactional Subscriber from a Backup (Replication Transact-SQL Programming)
-
How to: Initialize a Subscription Manually (Replication Transact-SQL Programming)
-
How to: Reinitialize a Subscription (Replication Transact-SQL Programming)
-
How to: Implement a Business Logic Handler for a Merge Article (Replication Programming)
-
How to: Execute Scripts During Synchronization (Replication Transact-SQL Programming)
-
How to: Work with Replication Agent Profiles (Replication Transact-SQL 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)
