Abstract

You are ahead of the curve. You’ve learned that you need to put your database in source control and you’ve set up some sort of automated build and regression testing process. (Or you’ve been to my continuous integration session.)

However, your deployments are still expensive and risky. You find it hard to keep track of what has been deployed to each environment. You don’t have a great deal of confidence that the production database is still in line with source control. You may have heard of the automated deployment functionality in VSTS or Octopus Deploy but you haven’t tried it yet… at least not for SQL Server.

In this session I’ll automate a deployment pipeline in a couple of different ways. I’ll discuss the importance of your database model as well as repeatable upgrade scripts and discuss the pros and cons of different approaches to automation. I’ll also discuss how to monitor for and protect yourself from database drift.

Slides

References

• Version control, LMGTFY
• Octopus Deploy documentation: SQL Server Databases, Paul Stovell (b|t)
• Declarative Database Development, Gert Drapers (b|t)
• Critiquing two different approaches to delivering databases: Migrations vs state, Alex Yates (b|t)
• Continuous Integration on a Dollar a Day (with a rubber chicken), James Shore (b|t)
• Redgate DLM Automation Cmdlet reference
• Database Deployment: The Bits – Database Version Drift, (build your own drift monitoring tool) Phil Factor (b|t)
• DLM Dashboard, (free drift monitoring tool)
• How Redgate Helped Define Our Process, Bob Walker (b|t)

Other talks I’ve delivered

• DevOps 101 for data professionals – how your jobs will change
• Database version control and deployment – model or migration scripts
• Getting CI Right for SQL Server
• Database DevOps Anti-Patterns
• My full speaker schedule

Need support implementing database release management?

If you are looking for database release managment training or consultancy DLM Consultants can help. We offer on-site consultancy as well as online workshops. Our full public workshops schedule is here.

To read more about our services or to contact us head to www.dlmconsultants.com.