Let's Get Scary and Continuously Deploy Database Changes

Explore the challenges and solutions for continuously deploying database changes in this NDC Oslo 2023 conference talk. Dive into the complexities of automating database deployments as part of a CI/CD pipeline, addressing issues such as undoing data changes, handling column modifications, and managing downtime. Learn strategies for successful database automation, including how to handle data type changes and remove columns without losing access to data. Discover the importance of automated testing in avoiding potential problems and explore both state-based and migration-based tools like SSDT and Flyway for rolling forward. Gain insights into using Azure for database deployments and understand how these concepts can be applied to various platforms. Equip yourself with the knowledge to confidently implement continuous deployment for databases, making the process less daunting and more efficient.

Introduction
Agenda
Automation
Data is a problem
Data stores
transactional databases
safe changes
dropping changes
naming changes
Renaming a column
Renaming a table
Protecting against broken business logic
Unit testing is your friend
Stack Overflow example
Time Check
Managing Database Source Code
Why are we always rolling forward
Item potency
SQL Server Data Tools
Rename
State Changes
Running the Migration