Export (0) Print
Expand All

Windows Synchronization Manager

SQL Server 2000

Windows Synchronization Manager is a utility available with Microsoft® Windows® 2000 and anywhere Microsoft Internet Explorer version 5.0 is installed. It allows you to synchronize or distribute data between instances of Microsoft SQL Server™ 2000 when using snapshot replication, transactional replication, or merge replication.

Windows Synchronization Manager is also a central location for synchronizing other applications including e-mail and offline Web pages. You can use Windows Synchronization Manager to schedule synchronizations or instruct Windows to synchronize selected items automatically when you log on or log off a computer, or when you undock a portable computer.

Windows Synchronization Manager allows you to:

  • Choose an alternate synchronization partner.

  • Add a new subscription.

  • Remove a subscription from Windows Synchronization Manager only.

  • Delete a subscription.

  • Reinitialize a subscription.

  • Reinitialize a subscription preceded by an upload of changes.

  • Change the update mode of an updatable subscription.

  • Attach a subscription database.

You can also use SQL Server Enterprise Manager to enable pull subscriptions for use in Windows Synchronization Manager, or you can programmatically enable subscriptions for use in Windows Synchronization Manager by using replication Microsoft ActiveX® Controls, SQL-DMO, or Transact-SQL system stored procedures.

For more information about Windows Synchronization Manager, see the Windows 2000 documentation.


Northwind Traders is using merge replication so that the remote sales force can view and update customer and orders information for their specific territories. In the Create Pull Subscription Wizard, the replication administrator could specify that the Merge Agent updates the subscription only on demand. When sales representatives are working offline, they can view their data and update customer and order information. When they reconnect to the Publisher, they can open Windows Synchronization Manager, and click the Synchronize button to synchronize their updates with updates made at the Publisher and at other Subscribers.

To open Windows Synchronization Manager


See Also

Synchronizing Data

© 2015 Microsoft