Edit

Microsoft Replication Interactive Conflict Resolver

  • Article

Applies to: SQL Server Azure SQL Database

The Interactive Conflict Resolver can be used for merge subscriptions that are synchronized using Windows Synchronization Manager. It allows you to view, compare, edit, and select the outcome for data conflicts. Replication also includes the Conflict Viewer, which allows you to view and modify conflict outcomes after they have been committed. The Interactive Conflict Resolver allows you to select the outcome during synchronization.

Note

Conflicts that involve logical records are not displayed in the Interactive Resolver. To view information about these conflicts, use replication stored procedures. For more information, see View Conflict Information for Merge Publications (Replication Transact-SQL Programming).

Options

Column name
The name of all columns in the table. One or more columns might have conflicting data. Regardless of which columns conflict, the entire winning row will overwrite the entire losing row.

Suggested Resolution
The suggested resolution provided by the conflict resolver for the article.

Publisher
The data value at the Publisher.

Subscriber
The data value at the Subscriber.

Accept Suggested, Accept Publisher, and Accept Subscriber
Click to accept the row that will be applied at either the Publisher or the Subscriber, depending on which one lost the conflict. If the Publisher lost the conflict, all other Subscribers will receive the winning row the next time they synchronize with the Publisher.

Resolve remaining conflicts automatically
Resolve all remaining conflicts using the suggested resolution provided by the conflict resolver for the article.

Log the details of the conflict for later reference
Logs the details of the conflict in system tables.

See Also

Interactive Conflict Resolution
View and Resolve Data Conflicts for Merge Publications (SQL Server Management Studio)
Synchronize a Subscription Using Windows Synchronization Manager (Windows Synchronization Manager)
Advanced Merge Replication Conflict Detection and Resolution