A Database DevOps Pipeline

on YouTube ↗46m

" summary

A concrete CI/CD pipeline for databases that actually versions schema and data and runs integration tests end to end is built using Docker containers, GitHub Actions, spawn ephemeral cloud databases and Red Gate tooling; the repo demonstrates four builds (state‑based and migrations, Windows and Linux) so you can see the tradeoffs. The pipeline spins up a throwaway neutral database, applies diffs or migration scripts, injects git hash and build date, runs app tests, and successfully deploys to Azure — no 3am manual scripts.

AI-written summary · about

" chapters (12)

1. 0:00Database DevOps intro
2. 2:08Why DevOps pipelines matter
3. 5:00Database deployment state
4. 9:56Database automation challenges
5. 13:08State vs migration approaches
6. 20:27Building automated pipeline
7. 27:30On-prem DB build demo
8. 31:42Cloud DB build demo
9. 35:59GitHub Actions demo
10. 40:17Migrations approach demo
11. 43:11Key takeaways
12. 45:18Q&A

" related talks

• 54mA Database DevOps PipelineRob Richardson · Great International Developer Summit 2023
• 01h 00mContinuous Integration and Delivery for DatabasesJimmy Bogard · NDC London 2020
• 50mBringing DevOps to the DatabaseSteve Jones · SQL Server Virtual Conference 2021
• 56mDeploying Docker for Database DevOps DominanceDaniel Mallott · NDC Sydney 2020
• 39mDatabase DevOps with ContainersRob Richardson · Data Con LA 2021
• 45mDev and Test Agility for your Database with DockerJulie Lerman · Craft Conference 2019
• 46mDatabase DevOps - It is Possible!Stephanie Herr · DevOps World | Jenkins World 2019 San Francisco
• 48mConnecting the dots of Azure SQL DevOpsMuazma Zahid · SQLBits 2023