MS SQL Server Change Tracking 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;

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;

Fixed an issue with the Enable change tracking command deactivation;

Fixed a bug that was causing the replication to fail when the source table was having non contigue primary keys;

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

Minor bugfixes and improvements.

Added abiliy to disable change tracking setup at agent’s setup wizard;

GSSD-321: Removed an unwanted control that was checking the existence of a physical primary key in a source table during the entity deletion phase;

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);

Fixed an issue causing the agent to fail enabling CT on databases that have special characters in their name (e.g. "my+database+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;