SymmetricDS Data Synchronization

SymmetricDS is an open-source data synchronization and replication software supporting bidirectional, multi-master database replication across heterogeneous platforms. Originally developed by Eric Long at JumpMind Inc. in 2007, SymmetricDS has over 1,000 stars as of 2026 and is used in retail, financial services, healthcare, and government sectors. Key features include: heterogeneous database support (synchronizing between MySQL, PostgreSQL, Oracle, SQL Server, DB2, Informix, Firebird, H2, HSQLDB, SQLite, and Amazon Redshift), multi-master replication (one-way, two-way bidirectional, and hub-and-spoke topologies), trigger-based change data capture (creating triggers on monitored tables to capture INSERT, UPDATE, DELETE operations into a data table, then batching and routing changes), data routing (configurable rules directing changes to nodes based on column values, subselects, JavaScript expressions, and built-in routers), data transformation (column mapping, value lookup, constant values, and custom transformations during sync), data loading (batching changes into channels with configurable sizes, with push and pull transport modes), conflict resolution (configurable strategies including manual, newest, oldest, and biggest wins), file synchronization (synchronizing files alongside database changes), initial load (populating target databases before continuous sync), HTTPS transport (secure TLS communication with client certificate authentication), cluster-safe operation (multiple instances with shared responsibility), and automated node registration and configuration distribution.