What is an expand-and-contract migration?
It is a staged schema change that first adds a compatible representation, then moves application reads and writes to it while the old representation remains available, and finally removes the old structure after all deployed code and data no longer depend on it. The stages let mixed application versions coexist during a rollout.
Answered in
A Safer Database Rename Takes Three DeploymentsExpand-and-contract migrations keep old and new application versions compatible while a schema changes, but they require observability and a rollback plan.
Read the full analysisOther questions this article answers
More databases questions
- Why not rename a database column in one deployment?
- Does expand-and-contract guarantee a zero-downtime migration?
- What is MariaDB Enterprise Platform 2027?
- What does the 56 percent throughput number measure?
- Does the release mean one database should run every workload?
- Is PostgreSQL 19 generally available?
- Can PostgreSQL 19 replace an existing major version in place?
- Which PostgreSQL 19 features should operators test?
Every answer on Crashtech is written by the editor of the article it comes from — never auto-summarised. Browse all answers or the Databases beat.