A community project sponsored by JumpMind Facebook Twitter Feed

Fast & Flexible Database Replication

SymmetricDS is open source database replication software that focuses on features and cross platform compatibility.

Cross Platform
Replicate data across different platforms, with compatibility for many databases. Sync from any database to any database in a heterogeneous environment.
Read More
Scale Out Performance
Optimized for performance and scalability, replicate thousands of databases asynchronously in near real time, and span replication across multiple tiers.
Read More
Flexible Configuration
Configure which tables and columns to sync, and in which direction. Subset rows and distribute them across databases. Combine, filter, and transform data.
Read More

SymmetricDS 3.10 was released, which includes 30 improvements, 5 new features, and 15 bug fixes! Here are some highlights:

Initial Loads

  • New sym_table_reload_status table tracks progress and statistics of loads by their ID
  • Queuing the load is faster using estimated row counts of tables
  • Extracting data is faster by eliminating SQL functions and formatting data in code
  • When loading multiple nodes, extracts are shared so common tables are only extracted once
  • Oracle/Tibero use two passes on tables with LOBs to optimize extraction under 4k limit
  • Loading is faster by deferring indexes and foreign key creation until the end of the load
  • New bulk loader support for Oracle (SQL*Loader) and Tibero (tbLoader)
  • Auto resolution of foreign key errors due to extracts running at different times on busy system

Change Data Capture

  • Enhanced fallback operations can now deal with chained foreign key and unique key exceptions
  • Faster insert performance on Postgres 9.5 using "on conflict" clause to detect conflicts
  • Oracle/Tibero LOBs optimized automatically for routing and extraction under 4k limit
  • Faster, more aggressive purge settings to keep system overall running better


  • Snowflake database as a load-only target with bulk loading

See the change log for more details.

Latest Release

SymmetricDS 3.11.3 is now available! Released on 2020-01-02.

There were 378 downloads this week.

Forum Feed

Feed not found.

Site Search

What are you looking for?


  • Common Batches Just Got Better
    Written by Eric Long

    Common batch mode was enhanced in SymmetricDS 3.11 to allow any group of nodes to share batches. Let's look at what common batches are and why this is a big deal for database replication with more than a couple nodes.

Find us on Facebook

Code Commits

  • rev 0e232aa by Eric Long
    1:23pm, 22 Jan 20
    Merge remote-tracking branch 'origin/3.10' into 3.11 Conflicts: symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSqlDdlReader.java
  • rev c3203fe by Eric Long
    1:11pm, 22 Jan 20
    0004259: Custom delete statement during initial load is overridden
  • rev 21d480c by Eric Long
    11:16am, 22 Jan 20
    0004257: Wizard list of tables for auto-create triggers is empty on SQL-Server
  • rev 00dc7d5 by Philip Marzullo
    11:12am, 22 Jan 20
    0004256: Oracle trigger creates row data and old data when streaming row
  • rev 34c19f0 by Hicks, Josh
    4:24pm, 21 Jan 20
    Merge 3.10 to 3.11
  • rev d4a37e9 by Hicks, Josh
    3:56pm, 21 Jan 20
    Merge remote-tracking branch 'origin/3.10' into 3.11 Conflicts: symmetric-client/src/main/java/org/jumpmind/symmetric/ClientSymmetricEngine.java symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/RouterService.java symmetric-db/src/main/java/org/jumpmind/db/platform/DatabaseNamesConstants.java symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriterConflictResolver.java
  • rev 5902094 by Hicks, Josh
    12:55pm, 21 Jan 20
    0004255: HBase data loader using HBase client API