Dacpac deployment task generating script to alter database properties

Nagesh CL 641 Reputation points
2023-03-16T16:28:04.2333333+00:00

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

Thanks.

Regards,

Nagesh CL

Azure SQL Database
{count} vote

Accepted answer
  1. GeethaThatipatri-MSFT 29,012 Reputation points Microsoft Employee
    2023-03-25T00:19:33.6933333+00:00

    @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

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful