Database Migration

A database migration is a versioned, repeatable change to a database schema (such as adding a table or column) that lets teams evolve the schema safely over time.

Migrations capture schema changes as ordered scripts checked into version control, so every environment — local, staging, production — can be brought to the same state reproducibly.

Good migration practice includes making changes backward-compatible where possible, testing rollbacks, and running migrations as part of deployment.

Because migrations are SQL against the database, they remain portable and transparent rather than hidden behind a proprietary abstraction.

Related terms

See it in practice

basefyio gives you database, auth, storage, and a REST API in minutes.

Get started