locked
can we have two different sync directions on same scope depending on the situation? RRS feed

  • Question

  • We have one client database (sql server 2005) syncing to Server version (sql server 2008) of the same database after it is backed up and restored to server. 

    Outside the sync box we are checking if any change happened  other than a change through sync service to server database (sql server 2008), code is written in sync service to call bi-directional sync between client and server else only upload sync is called. The sync service runs every 2 min. 

    Code black in our application where we set two directions based on situations:

                         Orchestrator.LocalProvider = localProvider;  //local provider configured for client (sql server 2005)

                        Orchestrator.RemoteProvider = remoteProvider; //this provider is for server (sql server 2008)


                         if (dirtyBit(scope,true) || syncRetry)
                        {

                            Orchestrator.Direction = SyncDirectionOrder.UploadAndDownload;
                        }
                        else
                        {

                            Orchestrator.Direction = SyncDirectionOrder.Upload;

                        }


                        SyncOperationStatistics syncStats = Orchestrator.Synchronize();

    So my question is can we have two different sync directions on same scope depending on the situation?

      
    • Edited by saisync Thursday, January 30, 2014 7:23 PM
    Thursday, January 30, 2014 7:23 PM

All replies

  • you can change the sync direction anyway you want. or even swap local provider and remote provider.
    Friday, January 31, 2014 1:52 AM
  • Thank you JuneT
    Friday, January 31, 2014 9:52 PM