FACTOID # 21: 15% of Army recruits from South Dakota are Native American, which is roughly the same percentage for female Army recruits in the state.
 Home   Encyclopedia   Statistics   States A-Z   Flags   Maps   FAQ   About 


FACTS & STATISTICS    Advanced view

Search encyclopedia, statistics and forums:



(* = Graphable)



Encyclopedia > Microsoft Synchronization Services

Microsoft Synchronization Services for ADO.NET is a data synchronization API that is being added to .NET Framework 3.5. Synchronization Services, modelled after ADO.NET data access APIs, allows synchronization of data across a master database and local caches.[1] It is intended to enable offline working with cached data in ADO.NET DataSets and synchronize the data back when connection is restored. It is database-agnostic, and allows incremental change tracking, which allows only the changes to be replicated rather than replicating the entire copy. It also supports working with local datasets that present a view of the data different from the native view. It can detect conflicting changes made to the same data element, but does not include any conflict resolution algorithm of its own, but lets application developers plug in any resolution scheme, as is suitable for the particular application.


Synchronization Services Architecture

Microsoft Synchronization Services uses a local SQL Server 2005 Compact Edition database for local caching, and the synchronization API provided as a set of DLLs. Synchronization Services is data source agnostic and works as long as a ADO.NET Data provider is available for the data source. Synchronization service can also support data sources other than a relational database, like an XML database or web service as long as a proxy is provided to abstract the data source and a data provider is available for the proxy. Synchronization Services can provide three types of synchronization: DLL is an abbreviation which can commonly mean: Data link layer, a layer in the OSI network architecture model Dynamically Linked Library, a binary application library file format in Microsoft Windows and IBM OS/2 (see the Dynamic linking section of the Library (computer science) article) Doubly Linked List, a... ADO.NET is a set of computer software components that can be used by programmers to access data and data services. ... A relational database is a database that conforms to the relational model, and refers to a databases data and schema (the databases structure of how that data is arranged). ... In Software engineering, an XML database is a data persistence software system that allows data to be imported, accessed and exported in the XML format. ... The W3C defines a Web service[1] as a software system designed to support interoperable Machine to Machine interaction over a network. ...

  1. Snapshot sync (download-only sync): The data in the data source (or a subset of it) is synchronized with clients.
  2. Upload-only sync: Data in the client is merged to the server database.
  3. Bidirectional sync: Both the server database and client caches can be modified in parallel and changes are synchronized with each other.

At the client side, the local database (used for caching) is connected exposed via the Client Synchronization Provider which handles the task of merging the downloaded data into the database, check for conflicts, and keep track of data which need to be synchronized. The Synchronization Agent uses the sync provider to create a Synchronization group out of the tables containing the changed data. A synchronization group contains only the data that has updated. Based on network availability and other parameters, the Synchronization Agent periodically connects to the server and uploads the changes, and if it is a bi-directional sync, finds out the changes at the server side store and downloads them. The server database is connected exposed via a Server Synchronization Provider which merges the changeset received from the client and also keeps tracks of the changes to the server database that needs to be transferred to the client.


  1. ^ Synchronization Services Books Online. Microsoft. Retrieved on 2007-06-14.

2007 (MMVII) is the current year, a common year starting on Monday of the Gregorian calendar and the AD/CE era. ... June 14 is the 165th day of the year (166th in leap years) in the Gregorian calendar. ...

External links

  • Microsoft Synchronization Services



Share your thoughts, questions and commentary here
Your name
Your comments

Want to know more?
Search encyclopedia, statistics and forums:


Press Releases |  Feeds | Contact
The Wikipedia article included on this page is licensed under the GFDL.
Images may be subject to relevant owners' copyright.
All other elements are (c) copyright NationMaster.com 2003-5. All Rights Reserved.
Usage implies agreement with terms, 1022, m