Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Let's Get Scary and Continuously Deploy Database Changes

NDC Conferences via YouTube

Overview

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.

Syllabus

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

Taught by

NDC Conferences

Reviews

Start your review of Let's Get Scary and Continuously Deploy Database Changes

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.