Database Migration Formats: Flyway, Liquibase, and Schema-as-Code
Manage database schema migrations with Flyway SQL scripts, Liquibase XML/YAML changelogs, and schema-as-code tools like Atlas and Prisma Migrate.
Published:
Tags: database, migration, devops
Database Migration Formats: Flyway, Liquibase, and Schema-as-Code Database schema changes are where well-run projects and poorly-run projects diverge. If your team is still running ad-hoc SQL on production and keeping a "list of changes" in a wiki, you're one bad deploy away from a schema mismatch you can't roll back. This guide covers the four serious options for schema migration tooling — Flyway, Liquibase, Alembic, and Prisma Migrate — with practical examples for each and guidance on team workflows. Flyway: SQL-First Migration Flyway is the simplest of the four. Migrations are plain SQL files named with a version prefix. No XML, no YAML, no ORM — just SQL. Migration File Naming Format: Version is any string that sorts numerically (1, 2, 3.1, 20240115) Double underscore separator…
All articles · theproductguy.in