MS ADO.net Sync Services

Sync Services for ADO.NET is a part of the Microsoft Sync Framework (MSF). MSF is a comprehensive synchronization platform that enables developers to add synchronization capabilities to applications, services and devices. MSF solves the fundamental problem of how to synchronize any type of data in any store using any protocol over any topology. Fundamental to MSF is the ability to support offline and collaboration of data between any types of endpoints (e.g. device to desktop, device to server, etc.).

Sync Services for ADO.NET enables synchronization between ADO.NET enabled databases. Since Sync Services for ADO.NET is part of the MSF, any database that uses Sync Services for ADO.NET can then also exchange information with other data sources that are supported by MSF, such as web services, file systems or custom data stores.

The primary focus of this document will be on synchronizing information between database systems and how Sync Services for ADO.NET helps developers avoid many of the common issues associated with OCAs.

ADO.net with VS2005 or VS2008 synchronization can be done with both the SQL server 2005 and 2008. MSDN link on various synchronization framework is here

So with MSF for ADO.net we will be able to synchronize the data stored in the mobile device or any other PC where the data is updated to the client database during the system is in offline. ie, we will be updating the data through our application to our local database and once the system or device is connected to the network it synchronize the data to the server it was mapped, with this any one can happily work offline.

For this, MS uses the Sql Server Compact Edition for the client database and SQL server 2005 or 2008 as the server.

The following link will give you more practical information on how this framework works for VS2008 SP1 and SQL Server 2008

For more information reach me by mail