Search code examples
mysqlsqlsql-serversymmetricds

MySQL, MSSQL - SymmetricDS

We are trying to replicate our Microsoft SQL Server schema to a MySQL server with SymmetricDS,

I got it running and works ok, but the next step I need to take is to put all of the system tables from SymmetricDS out of the schema we are replicating, to another schema, but I don't really know how can I do it.

And I was wondering if someone can point me in the right direction

Thank You!

Solution

  • You need to install SymmetricDS to the "config" schema. Specify the config schema in the JDBC URL.

    When you create your table triggers, you will need to provide the replication schema name. By default SDS will use the config schema.