79529284

Date: 2025-03-23 16:46:58
Score: 1
Natty:
Report link

Yes, SymmetricDS can certainly do this! As described in this official tutorial, you would need to set up Bidirectional replication:

  1. Download and review official documentation on how to install (Un-Zip).

  2. Copy 2 sample files (corp-000.properties and store-001.properties) from the "samples" sub-directory into the "engines" sub-directory.

  3. Review official documentation on how to edit engine files.

  4. Edit engines/corp-000.properties to connect node to SQL Server.

  5. Edit engines/store-001.properties to connect node to MySQL.

  6. Review group assignments of nodes and group links.

  7. Prepare to register store-001 node with with corp-000 using the registration.url property in the engine file.

  8. Configure test table for replication - on both databases.

  9. Start SymmetricDS! (use the bin/sym script at first, later you can run it as a service)

  10. Review logs and sym_outgoing_batch table for new entries.

Comment of this answer to refine it and help community!

And, if you have a different database or use case, please open a new question with the [symmetricds] tag attached.

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Pavel_JM