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.
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.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?