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.