Database Migration Articles
3 articles about Database Migration. Explore Spring Boot implementation, design, and operations across related topics.
-
How to Introduce baselineOnMigrate for an Existing Database with Spring Boot + Flyway - Initializing baselineVersion and flyway_schema_history
Explains the procedure for introducing Flyway after the fact into a database that is already running with existing tables. Covers the baselineOnMigrate, baselineVersion, and baseline-description settings, separate configuration on the Gradle/Maven plugin side, dry-run verification using flyway info, the mechanism behind the initial baseline marker row created in flyway_schema_history, and the staging verification procedure, all explained with implementation code.
-
How to Fix "Validate failed" / "checksum mismatch" in Spring Boot + Flyway - flyway repair and Production Recovery Steps
Explains the recovery steps for a Spring Boot app that fails to start due to Flyway's Validate failed: Detected failed migration or checksum mismatch errors. Covers the correct usage of flyway repair, why it should not be run carelessly in production, and manual fixes to the flyway_schema_history table, organized in a reverse-lookup format.
-
Database Migration Management with Flyway in Spring Boot - A Guide from Version Control to Production Deployment
A practical guide to safely version-controlling your database schema using Flyway in Spring Boot applications. Covers introducing spring-boot-starter-flyway, configuring application.properties, how the flyway_schema_history table works, handling existing databases with baseline-on-migrate, and troubleshooting with flywayRepair, all explained with concrete examples.