In this tutorial, you will learn using Flyway to version control database migration/evolution. Let's start building an example with Spring Boot, JPA/Hibernate, MySQL, and Docker.

What you will need

• JDK 8+ or OpenJDK 8+
• Maven 3+
• MySQL Server 5+ or Docker CE 18+

Project structure

Project dependencies

Define JPA Entity and Repository

Prepare SQL script for database migration

Application Configurations

hk-mysql refers to Docker Compose service defined in the below docker-compose.yml file

Run with Docker

Prepare Dockerfile for Java/Spring Boot application and docker-compose.yml for MySQL Server

Type the below command at the project root directory, make sure your local Docker is running

docker-compose up  

Access to MySQL Server docker container by issuing below bash command and key in hellokoding on Enter password:

docker exec -it hk-mysql mysql -p

Run with JDK/OpenJDK, Maven and MySQL Server local

Update hk-mysql on application.properties to localhost and type the below command at the project root directory

mvn clean spring-boot:run  

Testing time

Check the created schema and data by Flyway based on the prepared SQL scripts

Flyway also produced an additional table flyway_schema_history to manage schema version history

Keys to take away

• Using Flyway to version control database migration/evolution with SQL scripts.
• Hibernate DDL Auto should be disable when using with Flyway or on production environment, on application.properties, spring.jpa.hibernate.ddl-auto value should be validate or none (default).
• By default, Spring Boot and Flyway will find the migration script in resources/db/migration, you can change it on application.properties with spring.flyway.locations property.
• SQL script file name should follow Flyway convention https://flywaydb.org/documentation/migrations#naming

Source code

https://github.com/hellokoding/hellokoding-courses/tree/master/springboot-examples/springboot-flyway