Search code examples
symmetricds

How to sync different table structure in SymmetricDS?

How to synchronize different table structure in SymmetricDS?

Let say, I want to sync this tables:

(Server Node) Student | Id, Name

(Branch Node) Person | Id, Name, Birth Date

Thank you.

Solution

  • You can use an implied transform and set the source table to Student and the target table to Person. The Id and Name columns will automatically transfer. You could add a column transform as a child to this table transform to include a Birth Date with no source column. Im not sure where you get the birth date but there are other column transform types such as lookup etc that might help.