Dacpac deployment task generating script to alter database properties

Nagesh CL 641 Reputation points

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: -

User's image

"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?

User's image



Nagesh CL

Azure SQL Database
{count} vote

Accepted answer
  1. GeethaThatipatri-MSFT 29,012 Reputation points Microsoft Employee

    @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.



    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful