Using Sync Framework on databases with different schemas

Question

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.

Answer 1

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