Qlik Replicate: Microsoft SQL Server 2025 release and native JSON datatype support

[john_wang]

Previous versions of Microsoft SQL Server do not support a dedicated JSON data type.

For later versions, Microsoft announced the introduction of a native JSON data type (along with JSON aggregate functions). This new data type is already available in Azure SQL Database and Azure SQL Managed Instance, and is included in SQL Server 2025 (17.x).

SQL Server 2025 (17.x) became Generally Available (GA) on November 18, 2025.

At this time, the current Qlik Replicate major releases 2025.05/2025.11 do not support SQL Server 2025 or its native JSON data type yet.

Environment

• Qlik Replicate all versions
• SQL Server 2025 on-premises
• Azure SQL Database and Azure SQL Managed Instance (which share the same engine as SQL Server 2025)

Common Errors Observed if the table contains a JSON column in SQL Server 2025

SQL Server endpoint with SQL Server 2025 as the source

During the endpoint connection ping test, you may encounter:

SYS-E-HTTPFAIL, Unsupported server/database version: 0.
SYS,GENERAL_EXCEPTION,Unsupported server/database version: 0

MS-CDC endpoint with Azure SQL Database as the source

Since the Azure SQL Database version is always 14.x, the version check succeeds. However, Azure SQL DB already uses the SQL Server 2025 kernel, the task later fails during runtime with:

[SOURCE_CAPTURE  ]T:  Failed to set ct table column ids for ct table with id '1021246693'  (sqlserver_mscdc.c:2968)
[SOURCE_CAPTURE  ]T:  Failed to get change tables IDs for capture list [1000100]  (sqlserver_mscdc.c:3672)
[SOURCE_CAPTURE  ]E:  Failed to get change tables IDs for capture list [1000100]  (sqlserver_mscdc.c:3672)

Resolution

No workaround can be provided until support has been introduced.

According to the current roadmap, support for SQL Server 2025 and the native JSON data type is planned for the upcoming major release: Qlik Replicate 2026.5.

No date or guaranteed timeframe can yet be given. The support planned for 2026.5 is an estimate.

Internal Investigation ID(s)

00419519