SymmetricDS News

SymmetricDS 3.16.7 is released!
https://symmetricds.org/news/symmetricds-3-16-7-released/

This release includes 1 new feature and 5 bug fixes. Here are some highlights:

• Add support for the sql_variant column type (MS SQL Server).
• Expand number of variables available for substituting catalog and schema names in router configuration.
• Fix issue with the LONGVARBINARY column type for H2 databases (H2 versions 2.x).
• Rebuild triggers at startup if DDL-related parameters had changed.

SymmetricDS 3.15.20 is released!
https://symmetricds.org/news/symmetricds-3-15-20-released/
Note: This is a maintenance release for an older version of SymmetricDS.
This release includes 4 bug fixes:

• Improve detection of the leading ZWNBSP character for Unicode column types on Sybase ASE.
• Add detection for a German version of the ORA-00001 Unique Constraint error on Oracle.
• Update SQL syntax when loading data from H2 database.
• Update to a newer version of Eclipse Jetty library.

SymmetricDS 3.16.6 is released!
https://symmetricds.org/news/symmetricds-3-16-6-released/

This release includes 6 bug fixes. Here are some highlights:
* Improve support of text data in Turkey locale.
* Prevent sharing global BSH transform script parameter value across multiple co-hosted engines.
* Fix for lost leading ZWNBSP character when replicating UNITYPE data from Sybase ASE database.

SymmetricDS 3.16.5 is released!
https://symmetricds.org/news/symmetricds-3-16-5-released/

This release includes 8 improvements and 5 bug fixes. Here are some highlights:

• Speed up table look-ups by caching list of all tables found in a catalog or schema.
• Faster processing of registration requests from new nodes.
• More accurately extrapolate statistics about data changes to a 24-hour period.
• Fix compatibility issue with the sysdate as a default column value in Oracle.

SymmetricDS 3.16.4 is released!
https://symmetricds.org/news/symmetricds-3-16-4-released/

This release includes 2 new features, 8 improvements and 8 bug fixes. Here are some highlights:

• Improve handling of UNIVARCHAR columns when migrating data from Sybase to other databases.
• Add support for column aliases matching reserved words in Firebird.
• On PostgreSQL, triggers can be configured to capture the Truncate Table event and replay it on the target database.
• Multiple improvements to the "snapshot" procedure to better support our PRO-edition customers!

SymmetricDS 3.15.19 is released!
Note: This is a maintenance release for an older version of SymmetricDS.
This release includes 3 bug fixes:
* Order primary key columns when recapturing stranded data (related to changes from very-long running transactions) for tables with a compound primary key.
* Improve handling of UNIVARCHAR columns when migrating data from Sybase to other databases.
* Add check for multipart HTTP headers following the Vaadin library update.

SymmetricDS 3.15.18 is released!
Note: This is a maintenance release for an older version of SymmetricDS.
This release includes 3 improvements and 8 bug fixes. Here are some highlights:

• More robust handling of UNITYPES by DBCompare tool.
• Support UNIVARCHAR use in primary keys in Sybase ASE.
• Enforce row-level locking for runtime tables in Sybase ASE.

3.16.3 released

SymmetricDS 3.16.3 is released!
This release includes 2 new features, 8 improvements and 9 bug fixes. Here are some highlights:

• Improved support for (fast) custom Java routers by adding Engine and Log variables into scope.
• Introduced new transform type, which converts an entire row of data: JSON.
• Now supporting capture of the TRUNCATE TABLE events in Oracle database with a single parameter switch.
• Robust validation of configuration files during import processing.
• Updated the User Guide to reflect recent changes.

SymmetricDS 3.15.17 is released!
Note: This is a maintenance release for an older version of SymmetricDS.
This release includes 4 bug fixes. Here are some highlights:

Better verification of PostgreSQL permissions required for Log Mining (logical replication slots).
Improved handling of the VARCHAR column type for Latin-1 charset on Sybase ASE.

SymmetricDS 3.16.2 is released!
This release includes 1 new feature, 7 improvements and 9 bug fixes. Here are some highlights:

• Automatically execute H2 database compaction optimization script upon service shutdown.
• Improve PostgreSQL DDL trigger by supporting objects from non-default schema.
• Upgrade Spring, Swagger, Commons, and Vaadin libraries.

SymmetricDS 3.15.16 is released!
Note: This is a maintenance release for an older version of SymmetricDS.
This release includes 3 bug fixes. Here are some highlights:
* Improve handling errors encountered by a table load.
* Prevent initial load from failing due to concurrent updates.

SymmetricDS 3.16.1 is released!
This release includes 2 new features and 3 bug fixes. Here are some highlights:

• Report free disk space for main and file staging directories.
• Support DDL for Covering indexes on PostgreSQL (the INCLUDE clause for non-key columns).
• Improve compatibility with large UNITEXT-type columns on Sybase ASE.

SymmetricDS 3.15.15 is released!
Note: This is a maintenance release. The newest features can be found in the 3.16 version.

This release includes 2 bug fixes:
* Fix Sybase ASE unitext error when exceeding 8192 characters.
* Correct how stale or backlogged heartbeat batches deliver updated heartbeat time.

SymmetricDS 3.16.0 is released!
This release includes 2 new features, 10 improvements, and 2 bug fixes. Here are some highlights:

• Prioritize the new System channel and queue to coordinate responsive data sync.
• Skip file copy of staged batches when engines are hosted together (on the same server).
• Speed up data loading by caching column references when processing incoming batches.
• Multi-threaded routing by channel is now enabled by default.
• Improve compatibility with load balancers by accepting cookies.
• Upgrade the long-time favorite H2 embedded database to version 2.2.... read more

SymmetricDS 3.15.14 is released!
This release includes 2 improvements, and 3 bug fixes. Here are some highlights:

• Enhance DB Fill tool to commit generated records more regularly.
• More detailed messages expose underlying database restrictions for an attempted load.
• Tune accuracy of unrouted data count in a multi-server cluster.
• New unit test set up for DDL reader classes.

SymmetricDS 3.15.13 is released!
This release includes 1 new feature, 7 improvements, and 7 bug fixes. Here are some highlights:

• Support "covering" indexes (include extra columns in index for performance) for SQL Server.
• Add support for the Boolean data type for Derby.
• Include Trigger DDL when sending table schema.
• Support UUID column types (including DDL) directly for MySQL and MariaDB.
• New parameter to prevent deleting bulk load files (for testing and development)
• More robust logging of batch missing a batch ID.
• Fix tracking of table reload requests to completion.

SymmetricDS 3.15.12 is released! This release includes 1 new feature, 2 improvements, and 3 bug fixes. Here are some highlights:

• Preserve comments on stored procedures when loading DDL changes (new parameter dataloader.sql.event.strip.comments).
• More robust AppUtils static initialization of symmetric-impl.properties when running in containers.
• Improved detection of a negative default value in PostgreSQL.
• Speed up frequent channel detail queries by using cached data.
• Fix for recapture of stale data events for recently deleted records.

We're proud to announce that SymmetricDS has been selected as a finalist for the "Best DevOps DataOps / Database Solution" award! Each year the DevOps Dozen Awards honor the best and brightest in the industry. Please VOTE now for the ultimate winners. Voting ends December 31, 2024.

SymmetricDS 3.15.11 is released! This release includes 1 new feature, 2 improvements, and 4 bug fixes. Here are some highlights:

• New REST API to clear node host entries.
• Added support for pausing replication for one node.
• Improved detection of a default value for real/float column type in DDL batch targeting Interbase.
• Speed up frequent channel detail queries by using cached data.
• Fix for data reload events which contain a where clause.

SymmetricDS 3.15.10 is released! This release includes 3 new features, 5 improvements, and 9 bug fixes. Here are some highlights:

• Simplified deployment of WAR file on Tomcat version 10.
• Improved transform that converts NULL values.
• Enhanced performance of initial load on PostgreSQL using the UNLOGGED table mode.
• Expanded automatic conflict resolution of row deletes.
• New settings to control routing of DDL replication.
• Fix H2 DDL for changes to nullable columns.... read more

SymmetricDS 3.15.9 is released! This release includes 1 new feature, 7 improvements, and 13 bug fixes. Here are some highlights:

• Fixed empty versus null LOB on Oracle
• Added callback to purge listener that runs before purge
• Support auto update timestamps in DDL for MySQL/MariaDB
• Fixed DDL for table with missing PK and nullable UK
• Fixed precision of datetime2 in PK on SQL-Server... read more

SymmetricDS 3.15.8 is released! This release includes 8 improvements and 23 bug fixes. Here are some highlights:

• Filter extension point for extract phase
• SQL-Server support for user defined types when creating tables
• Support automatic ignoring of computed columns when loading tables
• Cancel previous initial load if a new initial load is requested
• Optimized Sybase ASE trigger execution
• Fixes to SQL-Server DDL table alterations... read more

SymmetricDS 3.15.7 is released! This release includes 2 features, 8 improvements, and 17 bug fixes. Here are some highlights:

• Column match router expression for has, starts with, and ends with
• Add symadmin export-sym-objects subcommand
• Add a --use-sym-db option to the DbImport and DbSql commands
• If auto resolve missing foreign key fails, try again
• SQL Server money data type error with commas ... read more

SymmetricDS 3.15.5 is released! This release includes 5 improvements and 16 bug fixes. Here are some highlights:

• Support Sybase ASE unitypes with dbcompare
• Support autosave setting with PostgreSQL JDBC driver
• Support unsigned columns on MySQL and MariaDB
• Use read uncommitted in some jobs to prevent deadlocks
• Updated Spring libraries to fix vulnerabilities

SymmetricDS 3.15.5 changelog

SymmetricDS 3.15.4 is released! This release includes 1 new feature, 8 improvements, and 21 bug fixes. Here are some highlights:

• Support for H2 2.2, although driver for H2 2.1 is still included for compatibility
• Improved performance of file sync when handling a large number of files
• Added TOP_RELATIVE_DIR variable for routing subsets of files
• Added support for N-types like NVARCHAR when creating tables across different platforms
• Fixed changing of web context root for custom deployments
• Upgraded SQL-Server driver to fix memory leak
• Upgraded MySQL, Postgres, and Jetty libraries to fix vulnerabilities... read more