Sync to the Web - Enable Offline Access to Web Data from any Data Store

At MIX 2008 Liam Cavanagh discusses how to use the Microsoft Sync Framework along with SQL Server Data Services to provide synchronization cabability across multiple applications.

In the demonstration, he synchronizes contacts between Microsoft Access, Outlook and SQL Server Data Services. However, by building new providers, any application can participate in synchronization.

Later in the presentation Neil Padgett goes through a detailed internals discussion of the Microsoft Sync Framework metadata and provider models.

WMV (High)

MP3

PSP (MP4)

WMA

WMV

Zune

iPod (MP4)

Comments

• Anonymous
  March 11, 2008
  PingBack from http://othercool.com/blog/2008/03/11/sync-to-the-web-enable-offline-access-to-web-data-from-any-data-store/

• Anonymous
  March 18, 2008
  Hi, I would like to know if we can use SQL Server 2005 as the client and Oracle as back end for the data synchronization? If so, could someone please share the code? Thanks, Rathi

• Anonymous
  April 02, 2008
  Hi Rathi, Yes, you can use Sync Services for ADO.NET to access an Oracle back-end server.  We do not yet have a client side provider for SQL Server 2005.  If you were willing to use SQL Server Compact on the client side then this would work.  There is a good example of this here: http://blogs.msdn.com/synchronizer/archive/2007/03/09/demo-v-offlineapplication-oracle-backend.aspx Alternatively you could use the Sync Framework to build two provider to talk between Oracle and SQL Server 2005.  This would be a little more work on your part though than Sync Services for ADO.NET. Liam