The latest update of Management Studio has an interesting preview feature called database devops. This feature is not automatically added if you updated from a previous version. In order to use the Database DevOps feature you’ll need to modify your installation through the Visual Studio installer.
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…