Full sync of table every time (i.e. not incremental) RRS feed

  • Question

  • I am not able to implement change tracking on my source database.  Yet I want my client database (SQL Server CE) to refresh at least at my application's startup.  This leads me to think I must drop and re-create the client tables each time during the sync.  Is this possible?  How?
    Wednesday, December 22, 2010 4:48 PM

All replies

  • Sync framework v2.1 SqlSyncProvider or DbSyncProvider uses triggers to track what has changed. If that's not possible, you could create a sync relatishiop between the Server and a SQLCe sync db and keep them in sync. But for the real client, you can just copy the sync db over and use it. In that case, sync time will be saved. Only coping of the ce sync db is needed, which still has some benefit. Not sure whether that may help in your case.
    Wednesday, December 22, 2010 6:35 PM