Large Scale No Downtime DB Migrations

When we were asked to move our SQL migrations to under 5 minutes of client downtime we said, “Impossible.” But we actually managed to achieve 0 minutes. In this talk, I will share how we achieved large scale (200 developers and terabyte sized databases) fully online migrations every month to our production SQL Server databases. We will cover the scripting changes, DB validations, and CI improvements we introduced to make this possible.

Matthew Campbell

D2L

Matt is the Development Manager for the Build, Deployment Automation, and Hardware Optimization teams at D2L. These teams focus on improving how D2L builds and ships their code as well as finding ways to optimize the code footprint in production. His teams are currently leading the charge on adopting Continuous Delivery and DevOps practices within D2L. Outside of D2L, Matt works for Conestoga College running courses on programming and general computer usage.