Getting Started Quickly with DB DevOps
summary
Demonstrates using Flyway and a free Fly Autopilot sandbox to go from zero to CI/CD in about 20–30 minutes, using GitHub Actions runners and a local DB to auto-provision dev/test/staging, capture schema changes, and generate migrations (forwards and rollbacks) automatically. Shows orchestration that knows per-database versions and can produce deployment reports across 500 databases, runs sandboxed builds/tests/drift checks, and delivers a reusable project that works end-to-end without touching production.
AI-written summary · about
chapters (16)
- 0:00Database DevOps intro
- 2:13Implementing DevOps challenges
- 4:00Redgate Flow Enterprise
- 5:26Flyway Autopilot intro
- 6:50Live demo setup
- 8:16GitHub repo for SQL Server
- 9:20GitHub Actions runner setup
- 10:01Flyway Desktop setup
- 11:05Sandbox database environments
- 11:48Tracking database changes
- 12:51Auto migration scripts
- 13:57Deployments orchestration
- 14:41Full CI/CD with GitHub
- 15:45CI/CD stages overview
- 17:51Security and customization
- 19:15Summary and call to action
related talks
20mGetting Started Quickly with DB DevOps- 20mGetting Started Quickly with DB DevOps
46mDatabase DevOps - It is Possible!
31mDevOps Practices for the Database Team
54mA Database DevOps Pipeline
46mA Database DevOps Pipeline
36mUnlocking the Benefits of Database DevOps and Automation
48mDevOps Discovery: Navigating the Database Landscape