Detailed logging while deploying DACPAC using sqlpackage.exe
In Visual Studio your database project is published without error to your environment. But somehow it fails in your deployment pipeline where it is published using sqlpackage.exe. Would it not be great if you could get some detailed logging of what exactly is going wrong?Add the /Diagnostics parameter to your publish command to get get more logging then you can handle 😉 Example below: In this case I found that my build was incorrectly overwriting…