Automating the update of a database structure can be challenging, especially when the target databases are different. In a product setup with roughly 100 database servers (25 productive), a solution for updating database structures was elaborated and implemented by Deloitte.
A dynamic deployment independent of the current version of the software connected to the database can be achieved with a Visual Studio Database solution and its build result, a dacpac. With the Azure DevOps task WinRM these dacpacs can automatically be deployed to Microsoft SQL Server databases. This solution design will be presented, and it will also be illustrated how that works in general. Furthermore, it will be shown what’s possible out of the box and for everything else solutions will be outlined and explained.