Dev and Test Agility for your Database with Docker

on YouTube ↗45m

" summary

Shows how to run SQL Server in Docker (Linux image) plus a Web API and a one-shot migration container so dev and CI get a fresh DB environment in seconds (engine boots in ~25s). Uses Docker Compose, Flyway for migrations, ASP.NET Core, xUnit and Azure Pipelines. Demonstrates spinning up DB, applying schema and seed SQL, running integration tests in CI — the sample repo runs the full flow and reports nine tests passed in the pipeline. This builds a reproducible dev/test stack that actually works end-to-end.

AI-written summary · about

" chapters (6)

1. 0:00Start
2. 8:19CONTAINERS ARE GREAT FOR DATABASES IN
3. 11:24USING SQL SERVER IN CONTAINERS
4. 25:58TESTS DOCKER COMPOSE WITH DATABASE CONTAINER
5. 29:25MIGRATIONS (SCHEMA AND/OR SEED DATA)
6. 41:42COORDINATED PIPELINES

" related talks

• 01h 07mDev and Test Agility for your Database with DockerJulie Lerman · NDC Oslo 2019
• 50mDev and Test Agility for Your Database with DockerJulie Lerman · DevReach 2022
• 30mDev and Test Agility for Your Database with DockerJulie Lerman · DockerCon 2020
• 56mDeploying Docker for Database DevOps DominanceDaniel Mallott · NDC Sydney 2020
• 54mA Database DevOps PipelineRob Richardson · Great International Developer Summit 2023
• 46mA Database DevOps PipelineRob Richardson · Øredev 2022
• 46mDatabase CI/CD with Docker Containers and Azure DevOpsChris Taylor · SQLBits 2020
• 39mDatabase DevOps with ContainersRob Richardson · Data Con LA 2021