MS SQL Server Change Tracking agent changelog

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;