Microsoft Office

From the Access Team Blog: Today’s guest writer is Liam Cavanagh from the Sync Framework and SQL Services team. They are doing some cool stuff that allows Access developers to store their app and data in the cloud using SQL Server Data Services. Liam is looking for people that want to beta test an upcoming release early next year. –Clint

Today at PDC we are announcing Codename “Huron”, a set of synchronization experiences built on top of the sync functionality in SQL Data Services’ cloud database and the Microsoft Sync Framework to provide business database sharing. Business database sharing offers a simple way to scale data to large numbers of users while not parting from the investment made in current technologies. It also enables users to subscribe and then edit the data locally in the format of their choice whether that is Office Access, SQL Server Express or SQL Server Compact and then push changes into SQL Data Services. The first end-to-end experience we will provide is for Office Access and will allow users to:

Publish databases to the cloud along with reports, forms and objects
Subscribe to published data and automatically configure the local database for sync
Make online changes through SQL Data Services and propagate those changes to subscribed users once they connect
Enable scheduled and background synchronization of data changes through SQL Data Services and then on to other subscribed users
Backup and restore of database applications to the cloud
If you are interested in joining our early beta, please email DataLabs@Microsoft.com with “Huron beta” in the subject. For more information on Codename “Huron”, please visit http://msdn.microsoft.com/sync

Microsoft Sync Framework is a comprehensive synchronization platform that enables collaboration and offline access for applications, services and devices. It features technologies and tools that enable roaming, sharing, and taking data offline. Using Microsoft Sync Framework, developers can build sync ecosystems that integrate any application, with any data from any store using any protocol over any network.

A key aspect of the Microsoft Sync Framework is the ability to create custom synchronization providers. A provider is a software component that represents a replica for synchronization. A replica is a particular repository of information to be synchronized, such as a file system on a handheld device. When representing a data source, a provider enumerates changes from its replica. When representing a destination, a provider applies changes to its replica. If the data at the source and destination differ in type or schema, each provider performs any necessary mapping or transformation.