Database deployment automation with DbUp
How do you manage your database deployments? You'll be surprised but this is one subject that seems to be a problem in many places I've worked. It all depends, of course, on how you run your deployments in general. So, what are the usual options? Manual - you copy all the files to your target server(s) manually and you deploy your database scripts by running them separately on each database server. Scripted - you use scripts, like PowerShell, to semi-automate your deployments by taking the steps from the manual process described above and running them in an automated way. …[read more]