0

I'm wondering whether I can sync two databases with some logic.

DbSyncTableDescription user = SqlSyncDescriptionBuilder.GetDescriptionForTable("User", sqlServerConn);
DbSyncTableDescription role = SqlSyncDescriptionBuilder.GetDescriptionForTable("Role", sqlServerConn);
DbSyncTableDescription usersInRoles = SqlSyncDescriptionBuilder.GetDescriptionForTable("UsersInRoles", sqlServerConn);

For example, sync administrators to user table. Do not sync staffs.

enter image description here

Thank in advance!

Win
  • 61,100
  • 13
  • 102
  • 181

1 Answers1

0

you can define a filter in your scope... see: Walkthrough: Defining Filtered Scope and Provisioning Server Database

or if you want more logic around what needs to be synched, you can intercept the changes in the ChangesSelected event...see: Manipulating the change dataset in Sync Fx

JuneT
  • 7,840
  • 2
  • 15
  • 14