CODEWITHSUNDEEP
microsoft-sync-framework
Sam
Sam

Reputation: 111

Using Sync Framework on databases with different schemas

Is it possible to use MS Sync Framework to synchronize different tables (with completely different structures) in different databases, assuming one of the tables has a primary key and the other a unique index whose values coincide with the first table's PK (but cannot be promoted to PK)? The column names can be different too.

Upvotes: 3

Views: 919

Answers (1)

JuneT
JuneT

Reputation: 7860

that should be possible, have a look at these series of posts:

Part 1 – Upload Synchronization where the Client and Server Primary Keys are different

Part 2 – Bidirectional Synchronization where the Client and Server Primary Keys are different

Part 3 – Synchronizing tables where Client and Server Primary Keys are different

Upvotes: 4

Related Questions