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].

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:

  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.

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.