CD for DBs: Database Deployment Strategies

on YouTube ↗23m

" summary

Maps practical deployment patterns to tradeoffs: compares SQL scripts (fast but error‑prone) with backup‑at‑deploy (safe but downtime and slow for TBs) and Microsoft DACPAC (easy rollback in many cases, MS‑only). Describes cluster‑based options — rolling deployments and partial/canary clusters — and tool integration (ElectricFlow supports automated rollbacks and rolling deploys). Emphasizes test backups, cloning lower environments, versioning DB metadata, and concrete failure scenarios developers and release engineers face.

AI-written summary · about

" chapters (16)

1. 0:00Intro
2. 0:13Evolution of Database Deployments
3. 4:36Distributed Development / Infrastructure
4. 5:17SQL Scripts / Rollback Scripts - Advantages
5. 5:40SQL Scripts / Rollback Scripts - Disadvantages
6. 6:13SQL Scripts / Rollback Scripts - Who should use
7. 7:20Backup at Deploy - Disadvantages
8. 7:47Backup at Deploy - Who should use
9. 10:21Other DB Deployment tools
10. 12:06Partial deploy (Canary)
11. 13:42Partial Deploy - Advantages
12. 14:20Partial Deploy - Disadvantages
13. 16:01Rolling deployment - Advantages
14. 16:36Rolling Deployment - Disadvantages
15. 17:37Things to remember
16. 19:23Talk to me

" related talks

• 01h 00mContinuous Integration and Delivery for DatabasesJimmy Bogard · NDC London 2020
• 50mBringing DevOps to the DatabaseSteve Jones · SQL Server Virtual Conference 2021
• 01h 00mLet's Get Scary and Continuously Deploy Database Changes!Dan Mallott · NDC Oslo 2023
• 31mDevOps Practices for the Database TeamPramod Sadalage · DevOpsDays Chicago 2017
• 48mDatabase Deployment Cowboys to Continuous Delivery HeroesAdam Close · NDC DevOps 2020
• 38mGetting Along With Your Db Ops TeamNick Demaster · DevOpsDays Salt Lake City 2016
• 45mEnabling Continuous Delivery with Database PracticesPramod Sadalage · Agile Singapore Conference 2016
• 27mDevOps and the Database BottleneckDan Zentgraf · DevOpsDays Boston 2019