SYNC FRAMEWORK 2.1 SNAPSHOT INITIALIZATION- SQL SERVER 2005 AND SQL SERVER 2008

Question

I am using sync fx 2.1, sqlsyncprovider in my application.

The bi directional sync is working good. But I am worried about initial sync. if it is empty database its fine, sometime I will have lot of data and first sync have trouble.

How to solve this? We don't have snapshot option in sqlsyncprovider. I read few msdn articles they say snapshot is for sql compact databases only.

---

ess

Answer 1

can you not pre-create the database, sync it, backup, and restore on client and do performpostrestorefixup? that would have the same effect as the SQL CE generate snapshot.

or generate snapshot to SQL CE, send the SQL CE db to client, sync SQL CE Db to client SQL instance.