Missing SQL Database options in dacpac for Microsoft Azure SQL Database target option in VS2022 17.5.5

[namangupta211]

We have a Visual Studio database project for which we also supply Query Store settings and MaxDop settings in the database settings Operational tab. The target platform we use in the project is “Microsoft Azure SQL Database”.

When we build the project with Visual Studio 17.4.4 the model.xml in the dacpac contains the supplied query store and max dop settings:

However when we build the project with Visual Studio 17.5.5 those settings are missing from the model.xml:

When we deploy the dacpac to our Azure Database it is reverting those settings to the default settings (MaxDop 8, QUeryStore Size 100 instead of the 512 we need).

As a temporary workaround we changed the targetplatform to “SQL Server 2022 or Azure SQL Database Managed Instance” since this does include those settings again.

[namangupta211]

Resolved.

[dzsquared]

This was shipped with DacFx 162.0.52 in May and is included in the Visual Studio 17.6 GA release.