Synchronize a Subscription Using Windows Synchronization Manager

Applies to: SQL Server Azure SQL Managed Instance

Microsoft Windows Synchronization Manager 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 View and Modify Pull Subscription Properties.

  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.

Note

Beginning with Windows Server 2008 and Windows Vista, 64-bit versions of the Windows Synchronization Manager cannot detect 32-bit subscriptions.

To enable the synchronization of pull subscriptions with Windows Synchronization Manager

  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. Select OK.

To synchronize a pull subscription with Synchronization Manager

  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.

To reinitialize a pull subscription with Synchronization Manager

  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. Select OK.

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

Note

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.

To set properties for a pull subscription in Synchronization Manager

  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. Select OK.

To remove a pull subscription from Synchronization Manager

  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. Select OK.

To use the Interactive Resolver

  1. Enable the article and subscription to use interactive resolution. For more information, see Specify Merge Replication properties.

  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.

Note

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.