SymmetricDS / News: Recent posts

SymmetricDS 3.17.2 is released!
https://symmetricds.org/news/symmetricds-3-17-2-released/

This release includes 2 improvements and 7 bug fixes. Here are some highlights:

• PostgreSQL now automatically installs the CITEXT extension when syncing tables with CITEXT columns.
• Watchdog job did not unregister nodes in certain cases.
• Better filtering in initial load (by reload channel) to correctly handle identically named tables from multiple schemas.

SymmetricDS 3.16.13 is released!
https://symmetricds.org/news/symmetricds-3-16-13-released/
Note: This is a maintenance release for an older version of SymmetricDS.
This release includes 1 improvement and 5 bug fixes. Here are some highlights:

• Watchdog job did not unregister nodes in certain cases.
• Better filtering in initial load (by reload channel) to correctly handle identically named tables from multiple schemas.
• Guard again null context in the Routing job.

SymmetricDS 3.17.1 is released!
https://symmetricds.org/news/symmetricds-3-17-1-released/

This release includes 1 new feature, 6 improvements, and 6 bug fixes. Here are some highlights:

• Significantly improve performance of a Full Load by creating indexes in parallel
• More robust node registration flow using internal JVM communication.
• Fix issue in transport manager occasionally pulling the same batch more than once.
• Additional variables available in the Column router.

SymmetricDS 3.16.12 is released!
https://symmetricds.org/news/symmetricds-3-16-12-released/

Note: This is a maintenance release for an older version of SymmetricDS.

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

• Add support for the SET column type on MySQL.
• Improve handling of  wildcards in source catalog or schema name.
• Upgrade Spring Boot to the 3.5.12 version (also updated Apache DBCP2 dependency).

Join the SymmetricDS Discord server to engage with our user community:
https://discord.gg/r6EN9v3P2j

SymmetricDS 3.17.0 is released!
https://symmetricds.org/news/symmetricds-3-17-0-released/

This release includes 3 new dialects, multiple improvements and bug fixes. Here are some highlights:

• Capture Changes Only Per Trigger.
• Prevent loops in DDL replication.
• Prevent multiple extracts for one Table Load request on MS SQL Server due to the timestamp truncation  issue in the JDBC  driver from jTDS.
• Job schedule frequency controls: minimum intervals for Push, Pull, and custom jobs (SQL, BeanShell, Java, etc.)
• PRO-only features for MS SQL Server and Oracle dialects.

SymmetricDS 3.16.11 is released!
https://symmetricds.org/news/symmetricds-3-16-11-released/

Note: This is a maintenance release for an older version of SymmetricDS.
This release includes 2 improvements and 2 bug fixes. Here are some highlights:

• Fix issue with multiple custom Java transforms on the same table.
• Prevent multiple extracts for one Table Load request on MS SQL Server due to the timestamp truncation issue with the JDBC driver from jTDS.
• Automate release notes generation and exclude dual-published tickets.

SymmetricDS 3.16.10 is released!
https://symmetricds.org/news/symmetricds-3-16-10-released/

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

• Expands PostgreSQL compatibility with native support for BYTEA binary data type.
• Prevents incomplete loads by blocking request processing until after the SyncTriggers job is done, ensuring data consistency during trigger synchronization operations.
• Fixes issue in MySQL log miner impacting fixed-size CHAR columns.... read more

SymmetricDS 3.16.9 is released!
https://symmetricds.org/news/symmetricds-3-16-9-released/

This release includes 2 improvements and 6 bug fixes. Here are some highlights:

• Fixed load prioritization to ensure CDC batches are processed after load is completed.
• Improved handling of tables located in non-default schemas.
• Expiration of the table name cache for log-mining and read-only scenarios.
• Fixed MariaDB SQL Explorer to successfully execute administrators queries.

SymmetricDS 3.15.22 is released!
https://symmetricds.org/news/symmetricds-3-15-22-released/

Note: This is a maintenance release for an older version of SymmetricDS!
This release includes 2 bug fixes:

• Improved handling of tables located in non-default schemas.
• Expiration of the table name cache for log-mining and read-only scenarios.

SymmetricDS 3.16.8 is released!
https://symmetricds.org/news/symmetricds-3-16-8-released/
This release includes 6 improvements and 4 bug fixes. Here are some highlights:

• Speed up the sending of deferred constraints and indexes.
• New index on outgoing_batch table prevents table scans.
• Option to speed up SQL Server metadata lookups by skipping non-standard indexes (compressed, filtered, with include columns).
• Better control of purge job duration and behavior (two new parameters).
• Improve compatibility of the the Ready Queues acceleration feature with certain network load balancers.
• Fix race condition during node registration and start of an initial load.

SymmetricDS 3.15.21 is released!
https://symmetricds.org/news/symmetricds-3-15-21-released/

Note: This is a maintenance release for an older version of SymmetricDS!
This release includes 2 security updates and 1 bug fix:

• Better control of purge job duration and behavior (two new parameters).
• Upgrade version of the JDBC driver for MS SQL Server.
• Better sanitization of SQL statement parameters.

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.