MS SQL Server Change Tracking agent changelog

GSSD-1419: Binary and varbinary columns take their declared length in the temp table used by large batches, instead of defaulting to one byte and failing every batch of 2000 bindings or more with "String or binary data would be truncated";

Added the source lag probe, reporting the unread change backlog and how far behind the last read transaction is;

GSSD-1320: Fixed error during bulk operation enable when schema already created;

Added support for older versions of the database that do not support TLS 1.2 (e.g. SQL Server 2008/2012 without patches). See TLS troubleshooting;

Target character columns: a value longer than its target column is now refused instead of being stored truncated with the transaction reported as written. Affects the IBM i series, Informix, MS SQL Server and Oracle targets, on the direct and the bulk write path alike (GSSD-1292, GSSD-1267);

MS SQL Server and Oracle targets: a failed insert batch is retried as an upsert only when the target already holds the row, so a rejection from the server is no longer turned into a truncation;

Fixed recursion protection missing in bi-directional pipelines that mix CDC and Change Tracking: every target now writes both markers, driven by the enableRecursionProtection flag alone;

Added logging of the rows rejected by a failed batch, behind the new logFailedBatchRows target property;

Added logging of the rows rejected by a failed batch, behind the new logFailedBatchRows target property;

GSSD-1243: Fixed staging table _OLD column suffix during bulk data mapping not resolving correct column informations;

GSSD-1130: Added deadlock prevention in CT read query using CTE;

GSSD-1120: Fixed deduplication logic for primary keys columns with case insensitive collation;

GSSD-1049: Added explicit cast for numeric columns with specific precision and scale to avoid precision loss during write operations with CTE;

GSSD-1042: Fixed class loader when using both MSSQL CDC and CT drivers in the same connection;

Added customizable transaction isolation option at source agent level;

Removed usage of select method "cursor" from the source agent default connection string;

Removed primary keys constraint from temp tables;

Fixed wrong configuration used for Transaction Isolation that can cause user selected value to be skipped;

GSSD-959 & GSSD-957: Added additional logging to help troubleshooting an issue with Japanese characters;

Added fixed length for unique identifier in Microsoft SQL Server;

Improved Microsoft SQL Server database creation to prevent leak of the connection in some rare cases;

Improved support for enhaced columns discovery (precision, lenght, scale);

Added customizable TRANSACTION_ISOLATION_LEVEL configuration option;

Fixed possible duplicate key error using bulk operations for target agent.

Snapshot performance enhancements;

GSSD-792: Backwards compatibility fix for MS SQL Server 2008 R2;

Introduce dynamic port discovery for SQL Server instances, enabled by default unless a different port is explicitly specified (other than the new default port 0);

Database pooling technology;

GSSD-766: In certain MS SQL Server 2019 configurations pre-KB5029377, the agent could throw an exception when attempting a Bulk load operation while storing a datetime value;

GSSD-716: Fixed a class cast issue during Bulk load driver operations;

Fixed bulk logic;

GSSD-716: Attempt to fix a class cast issue during Bulk load driver operations;

Replace drop of staging table with Truncate operation in case of Bulk loads usage;

Agent compatibility upgrade to Gluesync 2.2;