SQLBits 2015

Automating Your Database Deployments

Deploying your database changes to production can be nerve-wracking. We'll discuss methods that take the stress out of the process by ensuring that you practise your deployments using continuous integration before you ever get near production
Deploying your database changes to production can be nerve-wracking. We'll discuss methods that take the stress out of the process by ensuring that you practise your deployments usingcontinuous integration before you ever get near production. Automating thedeployment and testing processes through your testing and pre-productionenvironments can make the whole experience of production deployments morerepeatable, more reliable and more robust.

In this session, we'll explore the concepts of continuous integration and continuous delivery for databases – what to consider, the challenges, the benefits, the testing, and the crucialapproval gates necessary for a reliable production deployment. We'll discussthese and other release strategies as you think about how to evolve yourdeployment pipeline towards a more automated approach, starting with continuousintegration and ending at your production systems.