Search code examples
symmetricds

Can we implement symmetricds in databases which are identical but, tables have different PK id for same tables

Can I implement symmetricDS in identical databases?

My scenerio

I have to databases:

Database A

Database B

Whatever data change happens in either one of them should reflect in the other:

Current situation:

  1. Even though the DB are identical, database B have less tables that database A
  2. Consider a table tableA from database A and same table in database B But pk id for same records are actually different in two tables
  3. Can i expand and implement symmetricDS if i want to expand to a third database

Currently i am using a mapping table and API to handle datasync. Can i move to symmetricDS for syncing data

Solution

  • Yes, go ahead

    SymemtricDs allows for bidirectional synchronization of databases

    Only the tables of database B will be configured for synchronization. The extra tables from database A might be added to the mix using table transformation.

    As long as there are constraints of uniqueness on columns in, for example, database A that are PKs in database B that will not be a problem.

    You can add as many types and instances of those types of databases. Bear in mind that the graph of database relationships must satisfy the definition of a tree.