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 patch release fixes four bugs and makes six improvements. Fixes include handling large numerics and capturing "updates only" on SQL Server. Improvements include the ability to run SQL on a client before and after initial load, caching to improve performance, a column transform for accessing parameters, and UNC path support for the SQL Server bulk loader.
Release Notes: This patch release fixes four bugs and adds four improvements. Fixes include ones for an early commit bug which was causing lock timeouts, and accurate statistics on the initial load. Improvements include case insensitivity for transforms and better performance of some queries on PostgreSQL.
Release Notes: This release fixes six bugs, makes four improvements, and adds a new feature. Fixes were made to the bulk loaders (MySQL and SQL-Server) and transforms. Improvements were made to bulk loaders and the REST API. A new feature to capture only changed data was added for PostgreSQL.
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.