Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

Microsoft Replication Conflict Viewer, Updatable Subscriptions

SQL Server 2000

The Replication Conflict Viewer helps you view and resolve conflicts that may have occurred during replication synchronization. Conflicts occur when the same data is modified at two separate servers, for example, at a Publisher and Subscriber, or at two different Subscribers. The following conflicts can occur:

  • Update and insert conflicts. This conflict happens when the same data is changed at two locations. One change "wins," the other one "loses." For these conflicts, you have the option to keep the existing data (the data that won) or overwrite the existing data with the data that conflicted with it (the losing data). If you keep the existing data, it remains in the replica that won and the Microsoft Replication Conflict Viewer adds it to the replica whose update or insert operation initially lost. If you overwrite the existing data with the conflicting data, the replicas are changed to include the data that originally lost.

  • Delete conflicts. This conflict occurs when the same row is deleted at one location and changed at the other.

Conflicts are automatically resolved using the conflict resolver initially selected when the article was created. As conflicts are resolved during synchronization, the data from the losing row is written to a conflict table. The Replication Conflict Viewer allows you to review these conflict records and, potentially, modify your data.

The conflict resolver choices for queued updating subscriptions are:

  • Publisher wins and the subscription is reinitialized

  • Publisher wins

  • Subscriber wins

Note  The Replication Conflict Viewer displays conflicts that may occur as part merge replication or as part of snapshot or transactional replication whenever updatable subscriptions (immediate updating or queued updating) are used. In the case of snapshot and transactional publication using updatable subscriptions, you will be able to use Replication Conflict Viewer to observe the conflict, but you will not be able to alter the resolution the way you can with conflicts that occur during merge replication synchronization.

The following options are available in the Replication Conflict Viewer dialog box for snapshot or transactional publications that allow updatable subscriptions.

The specific options that appear depend on the type of conflict that has occurred. Not all options appear in all dialog boxes. Dates are displayed in ISO date-time format instead of the local format.

Options

Reason for conflict

View the

Show only columns with conflicts

If creating a new stored procedure article, enter the name of the article. If the article is already created, view the name of the article.

Show all columns

If creating a new stored procedure article, enter the name of the article. If the article is already created, view the name of the article.

Show

If creating a new stored procedure article, enter the name of the article. If the article is already created, view the name of the article.

Show or edit for resolution

If creating a new stored procedure article, enter the name of the article. If the article is already created, view the name of the article.

Keep winning change

If creating a new stored procedure article, enter the name of the article. If the article is already created, view the name of the article.

Resolve with this data

If creating a new stored procedure article, enter the name of the article. If the article is already created, view the name of the article.

Postpone resolution

If creating a new stored procedure article, enter the name of the article. If the article is already created, view the name of the article.

Log the details of the conflict for later reference

If creating a new stored procedure article, enter the name of the article. If the article is already created, view the name of the article.

Show:
© 2014 Microsoft. All rights reserved.