What is Server and Client type subscriptions in Merge Replication? How to select one of these during merge replication setup?
Server subscriptions are for:
- Republishing data
- Serve as alternate synchronization partners (This has been deprecated)
- 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.