How to Set Up Flyway On Your Database

FlywayDB is a tool that helps manage versions of your database. In this video, you’ll learn how to download Flyway and set it up to run on a database. You’ll learn how to create some simple scripts using basic SQL and have flyway run them to update your database.

This video uses MySQL on a Mac, but Flyway works on many databases such as Oracle, SQL Server, PostgreSQL, MariaDB, and more. It also works on Windows and other operating systems. The process is very similar for other databases and operating systems.

Timestamps:
00:00 Introduction
01:01 Download Flyway
02:37 Edit config file
05:03 Create first migration
08:25 Migrate database
10:20 Add another migration

[sherif]

i mean really and really GOOD tutorial. First time learning Flyway and you made it so easy - Thanks a lot!!

[dhartipatel]

This is easiest tutorial to follow. Thank you😀

[lauramarianne]

Have you ever considered becoming an audiobooks reader? :D your voice is so calming lol

[stefanowalkerpereirapontes]

EXCELLENT VIDEO
Question 1: For each database schema, is it mandatory to use a different folder containing the Flyway framework?
How can I manage different schemas centrally ?
My purpose is to manage DataWarehouses, non-transactional data models, OUTSIDE a development environment (not related to a software project).

Question 2: Do you know if Flyway has metadata quality control, or column naming rule validator, etc. Ex: columns with type INT must end with the suffix "...INT".

[thiagobellotto]

Hey! This is an AMAZING tutorial. Thank you!

Do you have plans to do one by using Docker? It would be super!