none
How to set SyncDirectionOrder directions values for different tables RRS feed

  • Question

  • Following are the Scenarios :-

    1. Set of Tables (Table1, Table2, Table3) data need to be synced from Central Server(MS SqlServer 2008) to client (MS SqlExpress Edition) and the SyncDirectionOrder.Download (ALWAYS)
    2. Set of Tables (Table4, Table5, Table6) data need to be synced from Central Server(MS SqlServer 2008) to client (MS SqlExpress Edition) and the SyncDirectionOrder.DownloadUpload

    Am using Sync Fx 2.1, let me know if i need to create different scopes to manage this scenario or can it be done in other ways...

    Regards,

    Vishal Mohan

     

    Friday, September 24, 2010 7:02 AM

Answers

  • afaik, the DbSyncProvider doesnt allow you to specify the sync direction per table unlike the offline provider where you can do it per table.

    so you're obvious choice is to create separate scopes for each of your scenario.

    hth,

    junet

    • Marked as answer by Vishal Mohan Friday, September 24, 2010 1:47 PM
    Friday, September 24, 2010 8:29 AM
    Moderator

All replies

  • afaik, the DbSyncProvider doesnt allow you to specify the sync direction per table unlike the offline provider where you can do it per table.

    so you're obvious choice is to create separate scopes for each of your scenario.

    hth,

    junet

    • Marked as answer by Vishal Mohan Friday, September 24, 2010 1:47 PM
    Friday, September 24, 2010 8:29 AM
    Moderator
  • Hey JuneT

    Thanks, i would like to know if there are any samples for creating different scopes and adding tables to that with different sync direction.

    BTW am referring to the following sample from http://code.msdn.microsoft.com/sync

    Database Sync:SQL Server and SQL Express N-Tier with WCF

     

     Vishal Mohan

     

     

    Friday, September 24, 2010 11:27 AM
  • in your case, you can create the second scope just like any other scope since the tables are not overlapping anyway. If you have installed Sync Fx 2.1, the documentation has walktroughs on how to define a scope.
    Friday, September 24, 2010 1:22 PM
    Moderator
  • does it requires different SyncOrchestrator too.

    Friday, September 24, 2010 2:06 PM
  • not necessarily, once you're done synching the first scope, just change the scope in the localprovider and remoteprovider and change the sync direction.

    Friday, September 24, 2010 2:19 PM
    Moderator