SymmetricDS 3.2.0 is released with 8 new features, 13 improvements, and 27 bug fixes! Documentation has also been updated and improved. Issue details are found in the changelog for 3.2.0. Keep reading for an overview of the new features and improvements.
Support for Synchronizing with SQLite
SQLite is now a supported dialect for both capturing changes and loading data. We’re proud to add another dialect that is also community supported and open source. SQLite is a compact, serverless database that runs cross-platform and “just works.” Especially suited for low-memory, low-overhead environments, the combination of SymmetricDS and SQLite provide a powerful application synchronization solution. Leverage all the features of SymmetricDS, including guaranteed data delivery, filtered synchronization, data transformation, and offline mode.
Send Change Data Over S/FTP
Change data is normally captured and sent to another SymmetricDS server over HTTP web protocol. Now, a new FTPDataWriter enables transferring the change data in a comma-separated (CSV) file over FTP or SFTP to a remote server. The data is tracked and delivered using the same batching mechanism that keeps status and retries errors. In the future, we plan to add more options to control the output of the CSV file. This feature can be used to integrate with remote systems that can pick up and load CSV files into their database.
Sometimes a table is missing a primary key definition or has additional unique constraints on it. In some cases, the source and target database might be designed with different primary keys that are not compatible for syncing data. Specifying the “sync keys” will define a synthetic primary key that is used for syncing update and delete statements.
Geometry Data Types
Support was added for geometric data types on SQL-Server and MySQL. Geometric data types represent two-dimensional spatial objects, such as points, lines, segments, boxes, circles, and polygons. By using the well-known text (WKT) format, SymmetricDS can capture and sync geometric data between SQL-Server, MySQL, Oracle, PostgreSQL, and Greenplum.
An audit table looks like the original table, but is named with a “_AUDIT” and contains additional columns for sequence, time, and change type. By configuring the Audit Table Router for your triggers, the audit table is automatically created and populated with change data. If the schema of the original table is altered, the audit table is also altered to match.
We hope you’re as excited as we are about the data synchronization possibilities with the new version of SymmetricDS. Head over to Download and try it out!