Can't Deploy Dacpac On Azure Devops Cd

I am building DacPac file from a database project using Visual Studio. Also, in the Debug Drop tab in Advanced Build Settings, I enabled the following options: Do not drop credent

Solution 1:

In AdditionalArgument you have to add

 /p:BlockOnPossibleDataLoss=false

But be aware that will delete you data.

If you use classic release it will be here:

in yaml

-task:SqlAzureDacpacDeployment@1displayName: Execute Azure SQL :DacpacTaskinputs:azureSubscription:'<Azure service connection>'ServerName:'<Database server name>'DatabaseName:'<Database name>'SqlUsername:'<SQL user name>'SqlPassword:'<SQL user password>'DacpacFile:'<Location of Dacpac file in $(Build.SourcesDirectory) after compilation>'additionalArguments:'/p:BlockOnPossibleDataLoss=false'