Export (0) Print
Expand All
Expand Minimize

publication Properties, Updatable Tab

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.

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. For more information, see Queued Updating Components.

See Also

Planning for Replication Options

Queued Updating Conflict Detection and Resolution

Updatable Subscriptions

Show:
© 2014 Microsoft