Abstract

This isn’t the dark ages any more. You’ve learned that you need to put your database in source control and you’re competent with source control systems like TFS or Git. You’ve also learned how to express your database in script form using a tool like SSDT, Flyway or Redgate.

However, you haven’t really looked at the build functionality in VSTS yet or gotten to grips with build servers like TeamCity or Jenkins. You still haven’t written as many automated tests as you know you should. Even if you have you aren’t sure how the process should work for SQL Server builds and tests.

In this session I’ll talk through the two most common ways to automate your database builds/deploys and the pros and cons of each. Then I’ll show you how to use tSQLt to build a suite of tests that can be run as part of your build process, giving you confidence in the quality of your code.

Slides

References

• Continuous Integration on a Dollar a Day (with a rubber chicken), James Shore (b|t)
• 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)
• tSQLt
• Three odd attitudes towards database unit testing that make me angry, Alex Yates (b|t)
• 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
• Database DevOps Anti-Patterns
• My full speaker schedule

Support implementing database CI

If you are looking for database CI 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.