After Synchronize() SQLCE is NOT updated. RRS feed

  • Question

  • Hi,

    -SQL Server: 2008 SP1
    -VS 2008 SP1
    -Microsoft Sync Framework 1.0
    -SQL 2008 -> SQLCE 3.5

    I'm trying to create a application that will sync just to the client (SQL CE). I create a winform project following some basic examples. I changed one row in SQL Server and expected to update the CE after the following code:

          Dim syncAgent As LocalDataCache1SyncAgent = New LocalDataCache1SyncAgent()
          Dim syncStats As Microsoft.Synchronization.Data.SyncStatistics = syncAgent.Synchronize()

    After Synchronize() the syncStats has DownloadChangesApplied = 1 (perfect).  But when I query SQL CE 3.5 table it does not show any change? Is there any commit or update I need to complete?

    One more piece of information: If I double click on LocalDataCache1.sync (Configure Data Synchronization) and then press OK, it syncs and updates the SQL CE 3.5 table. Works everytime.  


    Steven Ellis

    Friday, September 11, 2009 12:58 PM