visual-studioazure-devopssql-server-data-toolsdacpacssdt-2017

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:

Still, I get the following error in CD SQL Deploy: enter image description here


EDIT based on the advice of Krzysztof Madej, I have put the following additional arguments (they were working on another project), but for the argument, he proposed and for these ones I got this error:

is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

enter image description here enter image description here


Solution

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

    enter image description here

    in yaml

    - task: SqlAzureDacpacDeployment@1
      displayName: Execute Azure SQL : DacpacTask
      inputs:
        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'