MS SQL Server CDC agent changelog

GSSD-642: Added LocalDateTime truncation to avoid bigger strings during bulk copy;

Fixed float mapping in bulk operation;

Improved performance of the agent during bulk loads;

Updated vendor libraries.

Binary case improvements;

Fixed column names escaping for Bulk Operations;

Fixed primary keys columns management in staging table creation during bulk operations;

Refactored the management of the recursion protection handling: it now leverages a sidecar-table to store the last processed row id and track down the user who triggered the last update;

Added support for Bulk inserts, both while performing a Snapshot task and while performing a CDC task (For snapshot tasks, it is enabled by default, for CDC tasks it is disabled by default);

Fixed an issue that could halt the agent after encountering a column with a name containing ' symbol;

Fixed an issue that could prevent the agent to successfully write data to the target table in the case it has an identity field on a column that was not involved in the replication and not belonging to an indexed field;

Added support for compression at JDBC level (now enabled by default);

Minor bugfixes and improvements.

It is now possible to create entities even though the source table does not have a physical primary key, use case example: configure the table just for a snapshot task;

Added support for saving rows in which one of the columns is defined as a primary key with IDENTITY property;

Added explicit collate support;

Fixed datetime data type upsert with temp table;

Fixed uniqueidentifier data type support;

Fixed time data type precision loss;

GSSD-327: MSSQL improve support for unconventional table names (e.g. table names containing special characters at the end/beginning of the name);

Replaced the MERGE statement with UPDATE/INSERT statements to improve write performance. Gluesync from now on uses a combination of temporary tables, or CTEs, to speed up the write process based on context;

Fixed Bit / Boolean conversion;

Fixed MSSQL numeric data types mapping;

Fix duplicate columns in MSSQL discovery columns when clusted indexes are used twice or more with the same column name;