none
ado.net updates with the sync provider don't seem to stick until done RRS feed

  • Question

  • As a test, I added 100,000 records to a simple table, then executed the sync.  I found that if I interrupt it before it is finished, it starts all over again.  Is there an equivalent of "commit every 100 records" or something so the session does not have to start from scratch?  Or, is there a reason for this I should know about.

    Thanks,


    Peter Kellner http://peterkellner.net Microsoft MVP • ASPInsider
    Thursday, July 29, 2010 2:18 PM

All replies

  • afaik, if you're using the offline providers, the SyncGroup is treated as a single transaction. if you're using the collaboration providers, i believe the scope is treated as a single transaction as well. even if you enable batching, the batching only applies to the transfer of data but the all batches need to be completed before they are applied as a single transaction.

    Thursday, July 29, 2010 2:24 PM
    Moderator
  • Is there a way to do the sync and have it commit in batches somehow?
    Peter Kellner http://peterkellner.net Microsoft MVP • ASPInsider
    Thursday, July 29, 2010 2:36 PM
  • havent seen out of the box. i once worked on a custom offline provider for SQL Express where we commit by batch. A bit tricky doing the batching and setting the anchors at the same time.

    Thursday, July 29, 2010 2:47 PM
    Moderator