How to: Synchronize a Subscription Using Windows Synchronization Manager (Windows Synchronization Manager)

Updated: 14 April 2006

Microsoft Windows Synchronization Manager is available on all computers running Windows 2000 and later versions. It can only be used to synchronize subscriptions to Microsoft SQL Server publications if SQL Server is running on the same computer as Synchronization Manager (it can also be used to synchronize offline files and Web pages). To use Synchronization Manager:

  1. Enable the synchronization of pull subscriptions with Windows Synchronization Manager in the Subscription Properties - <Subscriber>: <SubscriptionDatabase> dialog box. For more information about accessing this dialog box, see How to: View and Modify Pull Subscription Properties (SQL Server Management Studio).
  2. Access Synchronization Manager through the Start menu in Windows.

Synchronization Manager allows you to use the Interactive Resolver for merge subscriptions. Typically, conflicts detected during synchronization are resolved automatically, but if interactive resolution is enabled, conflicts can be resolved by a user during synchronization. If a synchronization is performed outside of Windows Synchronization Manager (as a scheduled synchronization or an on demand synchronization in SQL Server Management Studio or Replication Monitor), conflicts are resolved automatically without user intervention, according to the resolver specified for the article.

  1. On the General page of the Subscription Properties - <Subscriber>: <SubscriptionDatabase> dialog box, select a value of Enable for the Use Windows Synchronization Manager option.

  2. Click OK.

  1. Launch Synchronization Manager using one of the following methods:

    • In Internet Explorer, click Tools, and then click Synchronize.
    • Click Start, point to Programs or All Programs, point to Accessories, and then click Synchronize.
    • Click Start, and then click Run. In the Run dialog box, type mobsync.exe in the Open field, and then click OK.
  2. In the Items to Synchronize dialog box, select the subscriptions to synchronize. Subscriptions are listed under the SQL Server instances installed on the computer.

  3. Click Synchronize.

  1. In the Items to Synchronize dialog box, select a subscription, and then click Properties.

  2. In the SQL Server Subscription Properties dialog box, click Reinitialize Subscription.

  3. Click Yes.

  4. Click OK.

    The next time the subscription is synchronized, by default a new snapshot is applied to the subscription database. For more information, see Reinitializing a Subscription.

Merge replication allows any outstanding changes to be uploaded to the Publisher before the snapshot is applied, but this option is not available from Synchronization Manager. To upload changes, synchronize the subscription before reinitializing it.

  1. In the Items to Synchronize dialog box, select a subscription, and then click Properties.

  2. View and modify properties on the following tabs:

    • Identification
    • Subscriber Login, Distributor Login, and Publisher Login (for merge replication only)
    • Web Server Information (for merge subscriptions on Subscribers running SQL Server 2005 or later)
    • Other

    It is recommended to use Windows Authentication for all connections. For information about the permissions required by the Distribution Agent and the Merge Agent, see Replication Agent Security Model.

  3. Click OK.

  1. In the Items to Synchronize dialog box, select a subscription, and then click Properties.

  2. In the SQL Server Subscription Properties dialog box, click Remove Subscription.

  3. Select an option in the Remove Subscription dialog box.

  4. Click OK.

  1. Enable the article and subscription to use interactive resolution. For more information, see How to: Specify Interactive Conflict Resolution for Merge Articles (SQL Server Management Studio).

  2. After the subscription begins synchronizing in Synchronization Manager, the Interactive Resolver launches automatically if interactive conflict resolution is enabled and there are conflicts for one or more articles. The Interactive Resolver displays conflicts one at a time, with a suggested resolution for each conflict (based on the resolver specified when the publication and subscription were created).

  3. Optionally edit any of the columns displayed in the Interactive Resolver, and then click one of the following buttons to resolve the conflict:

    • Accept Suggested
    • Accept Publisher
    • Accept Subscriber
    • Resolve All Automatically (all current conflicts are resolved without further input)

    The selected row is then applied to the Publisher and/or Subscriber; it is propagated to other nodes in the topology during subsequent synchronizations.

Edits are only applied if they are part of the row that is chosen for resolution. For example, if you make edits under Publisher, and then click Accept Subscriber, the edits are discarded.

Community Additions