Export (0) Print
Expand All

Updatable Subscriptions

SQL Server 2000

With snapshot replication or transactional replication, replicated data is by default read only; however, you have the ability to modify replicated data at the Subscriber by using updatable subscriptions. If you need to modify data at the Subscriber using snapshot or transactional replication, you can choose one of the following options depending on your requirements.

Updatable Subscription 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.
Immediate Updating with Queued Updating as a Failover Publisher and Subscriber are connected most of the time, but you may occasionally need to make updates offline.

© 2015 Microsoft