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