MS SQL Server CDC agent changelog

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;