Data not getting Sync'ed the first time- only for subsequent changes RRS feed

  • Question

  • Hi All,

    I have a database in a sql server 2008 instance whose data i am trying to download/sync to a local SDF file (SQL Server Compact SP2 3.5.8080.0).

    Issue: If my table has 100 rows and i attempt to sync, only schema is synced- no rows sync'ed. Now, I insert two new rows. When i sync, only these 2 rows are downloaded/synced into the sdf file.

    Is there a way to sync all the rows and schema in the first attempt itself..?

    Thursday, December 2, 2010 12:15 PM


  • which provider are you using and which sync fx version?

    if its sqlsyncprovider, try setting PopulateTrackingTable when you provision.

    • Marked as answer by Ujwal Iyer Thursday, January 27, 2011 2:07 PM
    Thursday, December 2, 2010 12:53 PM