MS SQL Server Change Tracking agent changelog

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;