Welcome to MSDN Blogs Sign in | Join | Help

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)
  • Published Wednesday, March 12, 2008 1:07 AM by liamca

    Comments

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

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

    Wednesday, March 19, 2008 7:28 AM by RathiSarov

    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

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

    Wednesday, April 02, 2008 6:11 PM by liamca

    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

    Anonymous comments are disabled
     
    Page view tracker