Replication
Updatable Subscriptions
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. |