// the find
jumpmindinc/symmetric-ds
SymmetricDS is database replication and file synchronization software that is platform independent, web enabled, and database agnostic. It is designed to make bi-directional data replication fast, easy, and resilient. It scales to a large number of nodes and works in near real-time across WAN and LAN networks.
SymmetricDS is a Java-based database replication tool that handles bidirectional sync across heterogeneous databases — MySQL to Oracle, Postgres to SQL Server, that kind of thing. It's been around since the early 2000s and has real production mileage in distributed retail and manufacturing scenarios where edge nodes have intermittent connectivity. The open-source edition is genuinely usable; the Pro edition locks away the management UI.
Breadth of database support is legitimately impressive — Oracle, SQL Server, MySQL, Postgres, DB2, Sybase, MongoDB, Snowflake, and more, with per-database quirks documented in separate appendices. The conflict resolution model is configurable and well-thought-out for bidirectional sync, which is the hard problem most replication tools paper over. It handles genuinely hostile network conditions — firewalls, WAN latency, intermittent connectivity — using a push/pull HTTP transport that works without direct database-to-database network access. Active development with a commit as recent as yesterday and a solid CI pipeline.
The management UI is paywalled behind SymmetricDS Pro, which means operating the open-source version means either writing config SQL directly or using CLI tooling — painful at scale. Configuration is database-table-driven (you configure triggers, routers, and channels by inserting rows into sym_* tables), which has a steep learning curve and makes version control of your replication config awkward. Log-based CDC is listed as a mode but trigger-based is the default and most battle-tested path, so you're adding database triggers to every replicated table — a non-trivial operational footprint. At 871 stars for a project this mature and capable, the community is small relative to alternatives like Debezium, which signals limited third-party tooling and fewer people who've hit your specific edge case.