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..?