Přihlásit
Microsoft.com
 
Microsoft
 
 
 
Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
Microsoft >
> 
> 
How to synchronize several tables in one transaction using SyncOrchestrator and SqlSyncProvider.

Odpovědět How to synchronize several tables in one transaction using SyncOrchestrator and SqlSyncProvider.

  • 4. dubna 2012 17:10
     
     
    Přihlásit se a hlasovat
    0

    As far as I know there are two ways of performing synchronization between databases:

    1. Using the SyncAgent class from Sync Framework 1.0.
    2. Using the SyncOrchestrator class from Sync Framework 2.1.

    The SyncAgent class allows to use the SyncGroup class to ensure that several tables will be synchronized in one transaction.

    Is it possible to achieve same functionality by using the SyncOrchestrator and SqlSyncProvider classes? If it it possible, please describe how to do this.

    Thank you!

     

Všechny reakce

  • 4. dubna 2012 23:39
    Moderátor
     
     Odpovědět
    Přihlásit se a hlasovat
    0
    Scope is the the equivalent of a SyncGroup in SyncOrchestrator/SqlSyncProvider. similar to a sync group, tables in a scope are synchronized in a transaction.
    • Označen jako odpověď Wolf007 5. dubna 2012 3:49
    •  
     
  • 5. dubna 2012 3:49
     
     
    Přihlásit se a hlasovat
    0
    Scope is the the equivalent of a SyncGroup in SyncOrchestrator/SqlSyncProvider. similar to a sync group, tables in a scope are synchronized in a transaction.

    Thank you for response. Sync groups have a benefit over scopes. It is possible to create several sync groups and run synchronization (SyncAgent.Synchronize) once for all sync groups. Using scopes I will have to run multiple synchronizations manually (SyncOrchestrator.Synchronize). But it is not big deal.

    There is one important thing. Tables in a scope are synchronized in one transaction only when SqlSyncProvider.ApplicationTransactionSize is set to 0. Otherwise multiple transactions may be created (depending on size of data) for a scope.