locked
Sync up database between 2 sqlce (.sdf) RRS feed

  • Question

  • I created a mobile application using the vs2008(vb.net, ado.net, sqlce 3.5) will like to sync up with the database on the desktop which is the sqlce too(sync up those 2 sqlce when the mobile device connects to the PC).  Do you have any example code that I can look at?  Thank you.


    • Moved by Max Wang_1983 Friday, April 22, 2011 6:41 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Tuesday, August 5, 2008 12:59 PM

Answers

  • The existing SQL Compact Provider does not support Compact to Compact sync.  Rather, the existing Compact Provider is tied to a client-server, hub-spoke scenario where you would like to sync SQL Compact with a central server that can be any database that has an ADO.NET provider.  However, Sync Services for ADO.NET is powered by the Microsoft Sync Framework which leverages a provider model so you are welcome to implement your own provider for the scenario you described.  Also note that syncing SQL Compact to SQL Compact is a common request so expect to see functionality that supports this scenario in the future.

     

    Regards,

     

    Sean Kelley

    Microsoft

    Program Manager

     

     

     

    Tuesday, August 5, 2008 4:10 PM
    Moderator