Export (0) Print
Expand All

Updatable Subscriptions

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 Type

Requirements

Immediate Updating

Publisher and Subscriber must be connected to update data at the Subscriber.

Queued Updating

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft