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.

Options

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

See Also

Other Resources

How to: Create a Pull Subscription (SQL Server Management Studio)
How to: Create a Push Subscription (SQL Server Management Studio)
Subscribing to Publications
Replication Properties
Replication Wizards
Updatable Subscriptions for Transactional Replication

Help and Information

Getting SQL Server 2005 Assistance