Blog Post

Azure SQL Blog
3 MIN READ

Database compatibility level 170 in Azure SQL Database and SQL database in Microsoft Fabric

theSQLSith's avatar
theSQLSith
Icon for Microsoft rankMicrosoft
Apr 17, 2025

Database compatibility level 170 is now the default for new databases created in Azure SQL Database and SQL database in Microsoft Fabric across all public regions.

The alignment of SQL versions to default compatibility levels are as follows: 100: in SQL Server 2008 and Azure SQL Database 110: in SQL Server 2012 and Azure SQL Database 120: in SQL Server ...
Updated Jun 19, 2025
Version 3.0
azure sql
azure sql database
theSQLSith's avatar
theSQLSith
Icon for Microsoft rankMicrosoft
May 01, 2025

Thank you Zuoken for the great question.

Database compatibility level 170 for database projects is supported in Microsoft.Build.Sql 2.0.0-preview.1.  Support for the new compatibility level within other tools like SSDT is coming soon.

CTaylor_Truegility's avatar
CTaylor_Truegility
Copper Contributor
Jul 23, 2025

theSQLSith​ - is there any update on when support for compatibility level 170 will be coming to SSDT? The new JSON data type and functions in 170 is great, but using JSON_ARRAYAGG function is causing errors in my build in SSDT.

  • DrewSkwiersKoballa's avatar
    DrewSkwiersKoballa
    Icon for Microsoft rankMicrosoft
    Jul 23, 2025

    CTaylor_Truegility​ - support in SSDT/Visual Studio is going to be later in the year. The JSON_ARRAYAGG function unfortunately isn't supported yet in Microsoft.Build.Sql at all, but as soon as it lands it'll be available first in VS Code's SQL database projects extension.