MicrosoftMicrosoftIs there an update coming for SQL Server Database Project in Visual Studio to allow me to target compatibility level 170? We've created a new Azure SQL Database, but the highest level I can target in Database Settings in my project is 160, even after I've selected Microsoft Azure SQL Database as the target platform. As a result when I try to deploy the dacpac I'm getting this error - "The compatibility level of the target schema 170 is not supported, which may result in undefined behavior. Please upgrade to a later version which supports this compatibility level."
MicrosoftThank 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.
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.
MicrosoftCTaylor_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.
