Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Replication
Development
 Windows Synchronization Manager
Community Content
In this section
Statistics Annotations (0)
Collapse All/Expand All Collapse All
Other versions are also available for the following:
SQL Server 2008 Books Online (October 2009)
Windows Synchronization Manager

Windows Synchronization Manager is a utility available with Microsoft Windows 2000 and later versions. If Microsoft SQL Server is running on the same computer as Synchronization Manager, you can do the following:

  • Synchronize a subscription.
  • Reinitialize a subscription.
  • Remove a subscription.

It is particularly useful for synchronizing subscriptions on SQL Server Express, because this version of SQL Server does not include SQL Server Agent, which, by default, runs the replication agents on other versions of SQL Server.

For example, Adventure Works Cycles uses merge replication (for more information about Adventure Works Cycles, see AdventureWorks Sample Databases). Remote sales representatives, who are running SQL Server Express on their laptops, can view and update customer and orders information for their specific territories. In the New Subscription Wizard, the replication administrator specified that the Merge Agent updates the subscription only on demand. When sales representatives are working offline, they can view their data and update the 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.

ms151193.note(en-us,SQL.100).gifNote:
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. For more information, see the Windows documentation.

To use Windows Synchronization Manager

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker