Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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