Schema Migration

9 items tagged with "schema-migration"

Filter by type:

Best Practices1

Expand and Contract Database Migration Pattern

A zero-downtime schema change technique that adds new structures, migrates reads and writes in phases, then removes the old structures once nothing depends on them.

Tutorials6

Tutorial

How to manage versioned database migrations with Flyway

Set up Flyway, write versioned SQL migrations, and apply them repeatably across environments with validation and history tracking.

Tutorial

How to manage database migrations with Liquibase changelogs

Define schema changes in declarative Liquibase changesets, apply and roll them back, and track state across environments.

Tutorial

How to run SQLAlchemy database migrations with Alembic

Generate, edit, and apply Alembic migrations for a Python SQLAlchemy project, including autogeneration and safe downgrades.

Tutorial

How to evolve a database schema with Prisma Migrate

Use Prisma Migrate to turn schema.prisma changes into versioned SQL migrations and apply them in dev and production safely.

Tutorial

How to perform a zero-downtime database schema migration

Use the expand-and-contract pattern to change a live schema without downtime, keeping old and new code compatible during rollout.

Tutorial

How to migrate a PostgreSQL database using logical replication

Move a PostgreSQL database to a new server with near-zero downtime using publications, subscriptions, and a final cutover.

Checklists1

Checklist

Schema Change Safety Checklist

Safety checks for applying database schema changes to production without locking tables or breaking running applications.

Glossaries1

Glossary

Schema Migration

The process of changing a database schema from one version to another