locked
SYNC FRAMEWORK 2.1 SNAPSHOT INITIALIZATION- SQL SERVER 2005 AND SQL SERVER 2008 RRS feed

  • 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

    Wednesday, February 20, 2013 5:05 PM

Answers

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

    • Marked as answer by saitrips Tuesday, March 5, 2013 3:21 PM
    Wednesday, February 20, 2013 10:07 PM