none
I can't see End of Microsoft.Synchronization.SyncOrchestrator.Synchronize() RRS feed

  • Question

  • I try  use the Microsoft.Synchronization.SyncOrchestrator.Synchronize() for Mirror my source database instance To my destination database(using sql server 2014, VS 2017).

    Always I can see successfully end of Synchronize(), When the Synchronization is First time.

    But After I change the scopeName , Sometimes The Synchronize() function don't end, never.

    When the Source Database is small(around 10mb), the Synchronize() was ended successfully, after minutes with changing scopeName.

    But When the Source Database is large(around 3gb), the Synchronize() was not ended never.

    Is there problem the Microsoft.Synchronization framework with Bigger database ?

    There is No Any Exception Message, just never end.

    My PC is notebook - with inter i5 2.5GHz and 8GB Ram.

    Dim scopeName As String = "TheScopeName"
    'after end of first syncro, I will do again syncro Just change the scopeName.
    '
    Dim SourceConnectionString As String
    Dim TargetConnectionString As String
    
    SourceConnectionString = s_src
    TargetConnectionString = s_dst
    
    Dim sqlServerConn As SqlConnection = New SqlConnection(SourceConnectionString)
    Dim sqlAzureConn As SqlConnection = New SqlConnection(TargetConnectionString)
    
    Dim myScope = New DbSyncScopeDescription(scopeName)
    
    '.....get table list for syncro...
    '
    Dim sqlServerProv As SqlSyncScopeProvisioning = New SqlSyncScopeProvisioning(sqlServerConn, myScope)
    
    If (sqlServerProv.ScopeExists(scopeName) = False) Then
     sqlServerProv.Apply()
    End If
    
    Dim sqlAzureProv As SqlSyncScopeProvisioning = New SqlSyncScopeProvisioning(sqlAzureConn, myScope)
    
    If (sqlAzureProv.ScopeExists(scopeName) = False) Then
     sqlAzureProv.Apply()
    End If
    
    Dim syncOrchestrator As SyncOrchestrator = New SyncOrchestrator
    
    syncOrchestrator.LocalProvider = New SqlSyncProvider(scopeName, sqlAzureConn)
    syncOrchestrator.RemoteProvider = New SqlSyncProvider(scopeName, sqlServerConn)
    syncOrchestrator.Direction = SyncDirectionOrder.UploadAndDownload
    
    syncOrchestrator.Synchronize()


    • Edited by soulessing Wednesday, June 21, 2017 10:38 AM
    Wednesday, June 21, 2017 9:33 AM