We are trying to setup SQL (dacpac) file deployment on Azure PaaS SQL using Octopus deploy. As part the of the setup we have completed the following steps -
Created database project in Visual Studio using Database project template (with Target Platform used is MS Azure SQL Database V12)
Build, Publish (.dacpac) and Push package to Octopus using Azure DevOps
Deploy Package (.dacpac) file in Web Server using step template “Deploy a Package”
- Deploy DACPAC file, using community step “SQL - Deploy DACPAC”
Here is where our deployment is failing with the below error log -
We are unable to locate the error in our process, and kind of struck. Please let us know if we are missing anything here.
Thanks in Advance,