Dev and Test Agility for Your Database with Docker

on YouTube ↗50m

" summary

Shows a runnable setup: a containerized SQL Server for Linux image (2017/2019 from mcr.microsoft.com), a Flyway migration container that runs EF Core–generated SQL scripts, and a web API container orchestrated with Docker Compose. Demos run integration tests against the real DB (8 unit/integration tests pass, later 9 after a schema change), use port 1620 and localhost:5114, explain volumes, connect_retries=20, detached vs foreground runs, and confirm the pipeline works end-to-end.

AI-written summary · about

" chapters (14)

1. 0:00Docker for databases
2. 1:59Local DB setup challenges
3. 7:41SQL Server licensing in Docker
4. 10:31SQL Server in Docker containers
5. 15:32Live demo: SQL Server setup
6. 22:16Demo app architecture
7. 25:50Docker Compose orchestration
8. 30:46Flyway migrations in Docker
9. 35:23Full stack with Docker Compose
10. 37:30DB via API interaction
11. 38:55Testing with Docker containers
12. 41:58Unit tests in containers
13. 44:54Schema changes with Docker
14. 48:27Summary and resources

" 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
• 46mDatabase CI/CD with Docker Containers and Azure DevOpsChris Taylor · SQLBits 2020
• 46mA Database DevOps PipelineRob Richardson · Øredev 2022
• 40mIntegration tests & testContainersIxchel Ruiz · Jfokus 2019