Edit

Subscription Type

  • Article

Applies to: SQL Server Azure SQL Managed Instance

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

See Also

Create a Pull Subscription
Create a Push Subscription
Subscribe to Publications