Dev and Test Agility for Your Database with Docker

on YouTube ↗30m

" summary

Shows a concrete workflow that runs SQL Server for Linux from mcr.microsoft.com SQL Server image inside Docker, seeds schema with Flyway migrations, and uses Docker Compose to orchestrate three services: DB, migration, and API/tests. Containers start fast (SQL Server ready in ~15 seconds), host ports mapped (examples 1601/1620 → 1433), migrations follow Flyway naming, tests run inside a container (8 then 9 tests pass), and volumes remain optional for ephemeral dev data or persistent production-like storage.

AI-written summary · about

" chapters (9)

1. 0:00The database gap
2. 2:21SQL Server on Linux
3. 4:56Benefits of containerized data
4. 6:58Running the SQL container
5. 10:41Automating migrations
6. 13:41Docker Compose orchestration
7. 17:24Demo: API and migration
8. 20:55Demo: Testing integration
9. 24:03Handling schema changes

" related talks

• 01h 07mDev and Test Agility for your Database with DockerJulie Lerman · NDC Oslo 2019
• 45mDev and Test Agility for your Database with DockerJulie Lerman · Craft Conference 2019
• 56mDeploying Docker for Database DevOps DominanceDaniel Mallott · NDC Sydney 2020
• 54mA Database DevOps PipelineRob Richardson · Great International Developer Summit 2023
• 39mDatabase DevOps with ContainersRob Richardson · Data Con LA 2021
• 46mA Database DevOps PipelineRob Richardson · Øredev 2022
• 46mSQL Server ContainersBob Ward · SQL Server Virtual Conference 2021
• 57mSQL Server Containers & Kubernetes - Going to Production!Tejas Shah, Amit Khandelwal, OJ Ngo · SQLBits 2024