SymmetricDS provides file and database synchronization with support for multi-master replication, filtered synchronization, and transformation across the network in a heterogeneous environment. It supports multiple subscribers with one-direction or bi-directional, asynchronous data replication. It uses Web and database technologies to replicate data as a scheduled or near-realtime operation. The software has been designed to scale for a large number of nodes, work across low-bandwidth connections, and withstand periods of network outage. It works with most operating systems, file systems, and databases, including Oracle, MySQL, MariaDB, PostgreSQL, MS SQL Server (including Azure), IBM DB2, H2, HSQLDB, Derby, Firebird, Interbase, Informix, Greenplum, SQLite (including Android), Sybase ASE, and Sybase ASA (SQL Anywhere) databases.
|Tags||Database Software Development Libraries H2 MySQL Oracle postgres firebird DB2 HSQLDB Database Engines/Servers synchronization replication Point-Of-Sale sql server Informix Derby Data synchronization|
|Operating Systems||OS Independent|
Release Notes: This release fixes four bugs and makes five improvements. Important fixes were made to staging, initial load, pull synchronization, and transforms. The purge retention was reduced to improve performance. The transforms were improved with a new "copy if changed" transform.
Release Notes: This release fixes eleven bugs and adds six improvements. Fixes apply to routing, audit tables, file sync, and dialects for Sybase and Postgres. The column match router was improved to allow "contains" and "not contains" expressions. File sync was improved to allow scripts to change the destination directory dynamically. Firebird triggers were improved to co-exist with user triggers.
Release Notes: This release fixes 10 bugs and adds 4 improvements. Fixes apply to dialects (H2, PostgreSQL, Sybase), file sync, wildcard triggers, transforms, and API. Improvements were made to math transforms, variable column transform, locking, and command invocation.
Release Notes: This release fixes two bugs and adds one improvement. Fixes were made to the start scripts and using multiple routers to the same node. The startup was improved to detect changes to the sync URL.
Release Notes: This release fixes six bugs and adds four improvements. Fixes were made to routing, the data gap detector, the upgrade process, and syncing smallints on Oracle. Improvements were made to the support snapshots, SQL events, shorter classpaths, and documentation.