How to: Specify Interactive Conflict Resolution for Merge Articles (SQL Server Management Studio)
To use interactive conflict resolution, it must be enabled for the article and the subscription:
- Enable interactive conflict resolution on the Resolver tab of the Article Properties - <Article> dialog box, which is available in the New Publication Wizard and the Publication Properties - <Publication> dialog box. For more information about using the wizard and accessing the dialog box, see How to: Create a Publication and Define Articles (SQL Server Management Studio) and How to: View and Modify Publication and Article Properties (SQL Server Management Studio).
- Specify that a subscription should use interactive conflict resolution in the Subscription Properties - <Subscriber>: <SubscriptionDatabase> dialog box. For more information about accessing this dialog box, see How to: View and Modify Push Subscription Properties (SQL Server Management Studio) and How to: View and Modify Pull Subscription Properties (SQL Server Management Studio).
After interactive resolution is enabled, resolve conflicts interactively during synchronization, using the Interactive Resolver. The Interactive Resolver is available through the Microsoft Windows Synchronization Manager. For more information, see How to: Synchronize a Subscription Using Windows Synchronization Manager (Windows Synchronization Manager).
To enable interactive conflict resolution for an article
On the Articles page of the New Publication Wizard or the Publication Properties - <Publication> dialog box, select a table.
Click Article Properties, and then click Set Properties of Highlighted Table Article or Set Properties of All Table Articles.
On the Article Properties - <Article> or Article Properties - <ArticleType> page, click the Resolver tab.
Select Allow Subscriber to resolve conflicts interactively during on-demand synchronization.
Click OK.
If you are in the Publication Properties - <Publication> dialog box, click OK to save and close the dialog box.
To specify that a subscription should use interactive conflict resolution
In the Subscription Properties - <Subscriber>: <SubscriptionDatabase> dialog box, specify a value of True for the Resolve conflicts interactively option.
Click OK.
See Also
Tasks
How to: View and Resolve Data Conflicts for Merge Publications (SQL Server Management Studio)
Concepts
Interactive Conflict Resolution