spring-boot-database-migrations

What problem does it solve?

This guide helps teams implement and enforce a consistent Flyway-based approach to evolving database schemas in Spring Boot projects, reducing drift and deployment risks.

Core Features & Use Cases

• Migration conventions: define a standard V[n]__description.sql naming scheme and a predictable file location under src/main/resources/db/migration.
• Change governance: provide rules to never modify applied migrations and to add new migrations for schema changes, with rollback guidance.
• Practical patterns: cover common changes such as creating new tables, adding columns, and establishing foreign keys, with PostgreSQL compatibility notes.
• Environment alignment: ensure migration behavior is consistent across development, staging, and production, including H2 vs PostgreSQL considerations.

Quick Start

Review and apply the latest migration scripts to update your database schema in a local development environment.