Updatable Subscriptions


Applies To: SQL Server 2016

With transactional replication, replicated data should be treated as read-only; however, you can modify replicated data at a Microsoft SQL Server Subscriber by using updatable subscriptions. If you need to modify data at the Subscriber, choose one of the following options depending on your requirements.

Updatable Subscription TypeRequirements
Immediate UpdatingPublisher and Subscriber must be connected to update data at the Subscriber.
Queued UpdatingPublisher and Subscriber do not have to be connected to update data at the Subscriber. Updates can be made while offline, and later synchronized between the Publisher and Subscriber.

Replicate Subscriber changes
Select the check box in the Replicate column for each Subscriber that should be able to make updates. For those Subscribers that can make updates, select the appropriate option from the drop-down list box in the Commit at Publisher column:

  • Select Simultaneously commit changes for an immediate updating subscription.

  • Select Queue changes and commit when possible for a queued updating subscription.

Create a Pull Subscription
Create a Push Subscription
Subscribe to Publications
Updatable Subscriptions for Transactional Replication

Community Additions