locked
Microsoft Sync Framework. sdf file not syncing with server RRS feed

  • Question

  • Hi,

    In my WM program, I use SQLCE. The .sdf file is syncronized with SQL server in my pc using SyncOrchestrator. Then, I copy the .sdf file to PDA and update certain tables by the WM application. Then, I copy back the updated .sdf file to PC and sync with the SQL server. The thing is, the updated data are not syncing with server. 

    WM SQL Version is 3.5. When i do any update in .sdf file when it is in PC, the sync is ok.but when i do any update when it is in PDA,the update is committed ,but sync doesnt occur. there are tracking columns for each table in .sdf which are automatically created by SyncOrchestrator. these columns are not tracking the changes.


    I need a solution please.

    Friday, March 23, 2012 5:35 AM

All replies

  • what version of SQL Compact are you running on the WM device?
    Friday, March 23, 2012 6:08 AM
  • Hi,

    sql server compact 3.5

    Friday, March 23, 2012 7:11 AM
  • if you are running Sync Fx 2.1, then you must be running SQL CE SP2. can you check that you have the same on the device and test again?
    Friday, March 23, 2012 7:33 AM
  • hi,

    thank you for your kind reply.

    YeS, in my PC i have Sync fw 2.1 and sql ce sp2.

    well in the device SQL Compact is 3.5. cannot find the service pack version.

    is there any sync framework to install to the Device?

    Friday, March 23, 2012 8:54 AM
  • here's the 3.5 SP2 for mobile devices: http://www.microsoft.com/download/en/details.aspx?id=8831

    Friday, March 23, 2012 9:08 AM
  • hi,

    thank you very much. now it's working.

    Friday, March 23, 2012 10:28 AM
  • just to expound on your problem. SP2 introduced the change tracking API to CE and this is what your Sync Fx 2.1 uses to synchronize.

    Your older CE version on the device doesnt have that API and thus, the changes are not logged in the tracking even if you are able to save changes.

    Friday, March 23, 2012 10:46 AM