Parallel writes, lower memory on large tables, Replicator in parallel

Highlights

• Synchronize can write to the target in parallel (1 to 4).
• The Replicator runs tables in parallel (1 to 4), with a child table waiting for its parent through the target's foreign key.
• Compare goes through an integer key in order, without loading the target in memory.
• Reading large tables is faster and uses less memory.

Also

• Compare checks dates to the microsecond.
• A full load without TRUNCATE permission stops and shows why.
• Warnings for triggers and GENERATED ALWAYS columns on Firebird and Oracle targets.
• MySQL zero dates arrive as NULL.
• Better suggested DDL for Firebird 4, MySQL UNSIGNED/TINYINT(1), SQLite and DECIMAL without precision.
• Job patterns for the Replicator, multi-table export and DB Extract.

Release notes

• 2.3.20261103.1516 Replicator: tables in parallel (1 to 4); a child table waits for its parent through the target's foreign key.
• 2.3.20261103.1448 Jobs: table name patterns in the Replicator, multi-table export and DB Extract.
• 2.3.20261103.1006 Compare: dates compared to the microsecond.
• 2.3.20261103.0954 Faster reading with less memory on large tables.
• 2.3.20261103.0929 Synchronize: parallel writes to the target (1 to 4).
• 2.3.20261103.0817 Compare: with an integer key, it compares in order without loading the target in memory.
• 2.3.20261103.0758 Connections: when the saved password cannot be read, the message explains why.
• 2.3.20261103.0549 A full load without TRUNCATE permission stops and shows why, instead of deleting row by row.
• 2.3.20261103.0539 End window without the shortcut "&", the connection name in the export log, and a dark title bar in the dark theme.
• 2.3.20261103.0516 Synchronize: warns about triggers, trigger-based generators and GENERATED ALWAYS on Firebird and Oracle targets.
• 2.3.20261103.0505 MySQL: a zero date (0000-00-00) arrives as NULL instead of stopping the copy.
• 2.3.20261103.0455 Firebird: Firebird 4 types in the suggested DDL.
• 2.3.20261103.0442 MySQL: UNSIGNED and TINYINT(1) in the suggested DDL.
• 2.3.20261103.0350 SQLite: size, precision and 64-bit INTEGER when reading the columns.
• 2.3.20261102.2152 DECIMAL without precision becomes (38,10) and respects the SQL Server (38) and MySQL/MariaDB (65,30) limits.

← All release notes