Tutorial. Flyway migrations with Spring Boot and MySQL

ORIL

Aug 15, 2023

Іn this video tutorial, ORIL`s Lead Software Engineer, Ihor Kosandiak, shows you how to use the Flyway DB migration tool with Spring Boot and MySQL.

Flyway, a database migration tool, is rapidly becoming popular in software development due to its user-friendly nature and seamless integration with existing application systems. Additionally, it offers support for a wide range of databases such as PostgreSQL, MySQL, Oracle DB, H2 db, and numerous others.

👨‍💻 Read more about Flyway migrations with Spring Boot and MySQL in our article https://oril.co/blog/flyway-with-spring-boot-and-mysql/

For this tutorial, we use Java 17, Spring Boot, MySQL, Maven, MacOS, and IntelliJ IDEA.

0:00 Intro

0:14 Project creation with Spring Initialzr

0:37 Creating a database entity class

1:17 Apply custom column names for database entity

1:36 Configure DB connection

2:08 Flyway principles: the first migration script

2:53 Populate tables with Flyway script

3:26 Modify column data type

4:17 Change a column name

4:57 Add a new column to existing tables