A Database DevOps Pipeline
summary
Shows a concrete CI/CD recipe: use Docker Compose, GitHub Actions, Spawn and containers to spin up transient databases, run either state-based and migrations-based pipelines, run schema and static-data compares with SQL Source Control / SQL Compare or Flyway, and run application integration tests against that neutral DB. The demo restores last night’s production backup every build (so backup validity is tested) and can spin a SQL Server test image in seconds to validate and then deploy.
AI-written summary · about
chapters (15)
- 0:00Introduction and setup
- 2:31What is a DevOps pipeline
- 6:47Database DevOps challenges
- 11:03Automating database pipelines
- 14:13State vs migration based approaches
- 23:23Build process for databases
- 29:48State-based demo
- 30:32Migrations-based demo
- 32:19Cloud-based DevOps pipeline
- 43:48Q&A: Migration vs state scripts
- 45:38Q&A: Production backups timing
- 47:46Q&A: Backup restoration speed
- 49:10Q&A: Container volumes optimization
- 49:56Q&A: Rollbacks and downscripts
- 52:16Summary and conclusion
related talks
46mA Database DevOps Pipeline
39mDatabase DevOps with Containers
45mDev and Test Agility for your Database with Docker
56mDeploying Docker for Database DevOps Dominance
50mDev and Test Agility for Your Database with Docker
01h 07mDev and Test Agility for your Database with Docker
50mBringing DevOps to the Database
30mDev and Test Agility for Your Database with Docker