1

What is Server and Client type subscriptions in Merge Replication? How to select one of these during merge replication setup?

1

Server subscriptions are for:

  1. Republishing data
  2. Serve as alternate synchronization partners (This has been deprecated)
  3. Resolving conflicts according to a priority

If your subscription(s) do not require this behavior then a client subscription will work just fine. This is covered in Subscription Type.

The Merge subscription type can be specified on the Subscription Type page of the New Subscription Wizard or by specifying a value of local (client) or global (server) for the @subscriber_type parameter in sp_addmergesubscription and sp_addmergepullsubscription. This is covered in Specify a Merge Subscription Type and Conflict Resolution Priority.

I hope this helps.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.