SymmetricDS

SymmetricDS 3.10.3 is released. This release includes 30 bug fixes and 7 improvements. Here are some issues to highlight: Better support for Java 11 and 12 Support for sticky session with AWS ELB DbExport option to exclude tables Handling of table ... [More] names containing special characters Reduced number of threads in ack service Fixed purging of incoming batches immediately for initial load Fixed syncing of data when primary key includes binary type Fixed enums for table creation on MySQL/MariaDB Fixed miscellaneous DbCompare bugs See the change log for more details: https://www.symmetricds.org/issues/changelog_page.php?version_id=510 [Less]

The initial data load is an important first step for data replication, so in the latest version 3.10 of SymmetricDS Pro, we worked hard to improve the Outgoing Loads screen to make it easy to follow progress and see how long the load will take. Here are some highlights that benefit long-running loads.

The initial data load is an important first step for data replication, so in the latest version 3.10 of SymmetricDS Pro, we worked hard to improve the Outgoing Loads screen to make it easy to follow progress and see how long the load will take. Here are some highlights that benefit long-running loads.

SymmetricDS 3.10.2 is released. Together with 3.10.1, these releases include 13 bug fixes and 10 improvements. (If you are using 3.10.1, it contains a serious query syntax error that can surface in routing when many data gaps accumulate, so we ... [More] strongly advise upgrading to 3.10.2.) Here are some improvements to highlight: Initial Apache HBase support Support for MongoDB clusters Re-clearing table if intial load extract is interrupted Here are the changelogs: https://www.symmetricds.org/issues/changelog_page.php?version_id=505 https://www.symmetricds.org/issues/changelog_page.php?version_id=504 [Less]

SymmetricDS now supports loading data and changes into Snowflake.   Capture changes in your relational database and sync them in near real-time into a Snowflake cloud data warehouse.

SymmetricDS now supports loading data and changes into Snowflake.   Capture changes in your relational database and synch them in near real-time into a Snowflake cloud data warehouse.

SymmetricDS 3.10 is now available! This is a new minor (X.Y) release with 30 improvements, 5 new features, and 15 bug fixes! We focused on improving the speed, reliability, and status of the initial data load. For change data capture, we ... [More] enhanced fallback operations to get a target back in sync while avoiding sync errors. This release includes support for the Snowflake data warehouse as a target database, and it can be bulk loaded using Snowflake's internal staging, AWS S3, or Azure managed storage. Here are some improvements in this release: 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 of common tables are shared 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 Databases Snowflake database as a load-only target with bulk loading Redshift database support is updated for latest version and options See the changelog for more details. [Less]

SymmetricDS 3.9.17 is released, with 10 bug fixes and 4 improvments. Some highlights: Data type fixes for Oracle RAW , SQL-Server datetime2, and PostgreSQL tsvector Cascade delete added to the table schema replication Estimated counts of tables ... [More] for faster setup of initial load Fix tables from altering on each startup on PostgreSQL 10 https://www.symmetricds.org/issues/changelog_page.php?version_id=493 [Less]

For a large database, the conventional initial load that extracts each table, one by one, can run for days. Not everyone can wait for that, so here are some tips to improve initial load performance on SymmetricDS.

Since the beginning of the SymmetricDS project, change data capture has been supported on Oracle and Oracle RAC. That's because Oracle is a popular database management system, ranking #1 on the DB-Engines Ranking for years. Recently, I helped ... [More] deploy SymmetricDS in a unique application environment based on Oracle RAC, where it was challenged to keep up with bulk, concurrent changes. By adjusting some new parameters specifically designed for RAC, we were able to meet performance requirements. [Less]