Subscription Type
Merge replication offers two subscription types: server and client (referred to in previous versions of Microsoft SQL Server as global and local, respectively). Subscribers with a server subscription can:
- Republish data to other Subscribers.
- Serve as alternate synchronization partners.
- Resolve conflicts according to a priority you set.
Most Subscribers do not require this functionality and can use a client subscription. Client subscriptions still allow conflict detection and resolution, but Subscribers are not assigned a priority: the first Subscriber to submit a change to the Publisher wins any conflicts that might arise from that change. For more information, see the "Subscription Types" section of How Merge Replication Detects and Resolves Conflicts.
Note
Subscription type cannot be changed after a subscription is created.
Options
- Subscription properties
For each Subscriber, select Client or Server from the drop-down list box in the Subscription Type column. For Subscribers with server subscriptions, enter a number between 0 and 99.99 in the Priority for Conflict Resolution column (the higher the number, the higher the priority for the Subscriber).
See Also
Other Resources
How to: Create a Pull Subscription (SQL Server Management Studio)
How to: Create a Push Subscription (SQL Server Management Studio)
Subscribing to Publications
Replication Properties
Replication Wizards