Getting Started Quickly with DB DevOps

on YouTube ↗20m

" summary

Sets up a working DB DevOps pipeline in under 30 minutes using Flyway and a free Fly Autopilot sandbox that clones a GitHub repo, installs a runner, and creates Dev/Test/Staging databases for you. Automatically detects schema changes, generate migrations (forward and rollback), runs sandbox CI/CD (GitHub Actions/Octopus), produces per-database drift checks and deployment reports, and can orchestrate releases across hundreds of databases without touching production.

AI-written summary · about

" chapters (16)

1. 0:00Database DevOps intro
2. 2:13Implementing DevOps challenges
3. 4:00Redgate Flow Enterprise
4. 5:26Flyway Autopilot intro
5. 6:50Live demo setup
6. 8:16GitHub repo for SQL Server
7. 9:20GitHub Actions runner setup
8. 10:01Flyway Desktop setup
9. 11:05Sandbox database environments
10. 11:48Tracking database changes
11. 12:51Auto migration scripts
12. 13:57Deployments orchestration
13. 14:41Full CI/CD with GitHub
14. 15:45CI/CD stages overview
15. 17:51Security and customization
16. 19:15Summary and call to action

" related talks

• 20mGetting Started Quickly with DB DevOpsHuxley Kendell · SQLBits 2024
• 20mGetting Started Quickly with DB DevOpsHuxley Kendell · SQLBits 2022
• 46mDatabase DevOps - It is Possible!Stephanie Herr · DevOps World | Jenkins World 2019 San Francisco
• 48mDevOps Discovery: Navigating the Database LandscapeHuxley Kendell, David Ong · SQLBits 2022
• 54mA Database DevOps PipelineRob Richardson · Great International Developer Summit 2023
• 46mA Database DevOps PipelineRob Richardson · Øredev 2022
• 31mDevOps Practices for the Database TeamPramod Sadalage · DevOpsDays Chicago 2017
• 48mDevOps Discovery: Navigating the Database LandscapeHuxley Kendell, David Ong · SQLBits 2024