The Replication Conflict Viewer helps you view and resolve conflicts that occurred during the merge replication process. Conflicts occur when the same data is altered simultaneously at two separate locations, for example, at a Publisher and Subscriber, or at two different Subscribers. Conflicts can also occur when data changes made at one location violate constraints at another location (known as a divergent conflict). After a divergent conflict has occurred, the data at the two locations are no longer identical until the conflict is resolved.
These conflicts are resolved based upon the priority set when the subscription was created, or the user-created resolution procedures. The Replication Conflict Viewer allows you to review the manner in which these conflicts have been resolved and make changes to these resolutions.
If you choose to ignore a divergent conflict, you should resolve the underlying conflict between data constraints as soon as possible. Start by logging the details of this conflict and then sending the log entry to your system administrator. Then examine the constraints on your data at each location to make sure they are consistent across sites.
This table shows the options and their functions that are available in the Replication Conflict Viewer dialog box.
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 datetime format instead of the local format.
|Use this||To do this|
|Reason for conflict||View the specific reason for the conflict that occurred and the way in which the conflict was resolved.|
|Show only columns with conflicts||Display the GUID (unique identifier) column and only the columns that have conflicts.|
|Show all columns||Display all the columns in the row.|
|Keep existing data||Accept the current resolution of the conflict.|
|Keep revised data||Accept the current resolution of the conflict, but include the revisions made in the edit boxes.|
|Keep data deleted||Accept the current resolution of the conflict; data will remain deleted.|
|Ignore conflict||Mark the conflict as resolved without making any changes. This results in a discrepancy and should be resolved through other means as soon as possible.|
|Overwrite with conflicting data||Overturn the way the conflict was resolved and keep the conflicting data shown.|
|Overwrite with existing data||Overturn the way the conflict was resolved and keep the existing data shown.|
|Overwrite with revised data||Overturn the way the conflict was resolved with the revisions made in the edit boxes and keep the revised data shown.|
|Delete data||Delete the data shown in the columns.|
|Log the details of this conflict for later reference||Make a copy of the conflict and store it in a separate log file for later use. The file is stored in Windows directory\profiles\user\Application Data\Microsoft\Database Replication\UnresolvedConflicts.log.|