0 out of 1 rated this helpful - Rate this topic

Subscription Type

SQL Server 2012

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.

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).

Concepts

Create a Pull Subscription

Create a Push Subscription

Subscribe to Publications

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD