Automate your DB deployment with DbUp

Databases and applications should coexist in the same deployment pipeline. They should be versioned and packaged in the same way and they should share a single development lifecycle. This will enable the team to treat DB deployment like any other software deployment.  To achieve this with SQLServer you can use DbUp, it’s a simple but very effective migration tool.  Have a look at they getting started doc: https://dbup.readthedocs.io/en/latest/