Database Synchronization Scenarios

This section of the documentation includes content for client-server, peer-to-peer, and mixed topology synchronization scenarios. For more information, see Overview [Synchronizing Databases].

Using the Sync Framework Documentation

The topics in the Sync Framework documentation provide an introduction to the Sync Framework database synchronization API, example code, and an API reference. You can find the API reference for peer-to-peer synchronization in Microsoft.Synchronization, Microsoft.Synchronization.Data, Microsoft.Synchronization.Data.SqlServer, and SqlCeSyncProvider.

If you are new to database synchronization with Sync Framework, we recommend that you read the documentation in the following order:

1. Learn about the architecture of the API and the most important classes in Architecture and Classes for Database Synchronization.

2. Review the code for basic applications provided in the tutorials, depending on the type of database you are synchronizing:

   • Tutorial: Synchronizing SQL Server and SQL Server Compact

   • Tutorial: Synchronizing SQL Server and SQL Express

   • How to: Configure and Execute Synchronization with SQL Azure [Delete]

3. Get a sense of how to handle synchronization for databases other than SQL Server by browsing through the topics in Synchronizing Other ADO.NET Compatible Databases.

These topics contain sample code. Additional samples are available in the Sync Framework SDK and on Code Gallery.

In This Section

• Architecture and Classes for Database Synchronization
  Describes how Sync Framework can be used in peer-to-peer applications; and describes the major classes that are available in the API.

• Synchronizing SQL Server and SQL Server Compact
  Describes how to use SqlSyncProvider and SqlCeSyncProvider to synchronize SQL Server and SQL Server Compact databases.

• Synchronizing SQL Server and SQL Express
  Describes how to use SqlSyncProvider to synchronize SQL Server and SQL Server Express databases.

• Synchronizing SQL Azure [Delete]
  Describes how to use SqlSyncProvider to synchronize with databases.

• Synchronizing Other ADO.NET Compatible Databases
  Describes how to use DbSyncProvider to synchronize databases other than SQL Server.

• Offline-Only Scenarios
  Describes how to use client and server database synchronization scenarios.

• Microsoft.Synchronization, Microsoft.Synchronization.Data, Microsoft.Synchronization.Data.SqlServer and Microsoft.Synchronization.Data.SqlServerCe
  Provides a complete reference to the Sync Framework API for peer-to-peer database synchronization. This reference covers public types and members in Microsoft.Synchronization.dll, Microsoft.Synchronization.Data.dll, Microsoft.Synchronization.Data.SqlServer.dll and Microsoft.Synchronization.Data.SqlServerCe.dll.

See Also

Concepts

Synchronizing Databases