Dacpac deployment task generating script to alter database properties

Question

Hi Team,

We are using "Azure SQL DacpacTask" in release pipeline for azure sql database deployment. The incremental scripts are being generated. But the problem is, it contains few sql statements to alter database settings: -

"Deploy database properties" option is UnChecked in the database project (Visual Studio Solution). But still the scripts to alter db properties are being generated. How to disable the generation of these alter statements?

Thanks.

Regards,

Nagesh CL

Answer 1

@Nagesh CL Thanks for your patience, sorry for the delay in my response,

The SSDT interface for “deployment options” is for performing the publish action in SSDT.  These options won’t apply to deploy/publish operations in other interfaces such as ADO pipelines.

The pipeline task for “Azure SQL Dacpac Task” has a field for additional parameters where users can input additional options, such as /p:ScriptDatabaseOptions=False.  More information about the available properties is available in the SqlPackage documentation - https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-publish?view=sql-server-ver16#properties-specific-to-the-publish-action

I hope this information helps.

Regards

Geetha