publication Properties, Updatable Tab
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.
The following options are available on the Updatable tab of the publication Properties dialog box.
Options
Allow immediate updating subscriptions
View whether this publication allows data modifications made at the Subscriber to be immediately propagated to the Publisher and then to other Subscribers. You cannot change this property after the publication is created. If you need to change it, you will have to delete the publication and re-create it.
Allow queued updating subscriptions
View whether this publication allows data modifications made at the Subscriber to be stored in a queue and propagated to the Publisher at a later time. You cannot change this property after the publication is created. If you need to change it, you will have to delete the publication and re-create it.
Report conflicting data changes at the Publisher only
Specifies that conflict reporting will occur only at the Publisher. If you clear this option, conflict reporting will occur at the Publisher and Subscriber.
Keep the change made at the Publisher
Select to indicate that when a conflict occurs, the data change made at the Publisher wins the conflict.
Keep the change made at the Subscriber
Select to indicate that when a conflict occurs, the data change made at the Subscriber wins the conflict.
Reinitialize the subscription
Select to indicate that when a conflict occurs, the subscription will be reinitialized.
In a SQL Server database
Select to indicate that data modifications made at the Subscriber will be stored in a SQL Server database. This option is only available if queued updating is enabled.
Using Microsoft Message Queuing
Select to indicate that data modifications made at the Subscriber will be stored using Microsoft Message Queuing. This option is only available if queued updating is enabled.
See Also
Planning for Replication Options