Flyway – Database Migration

Database Migration

Flyway

• Open source database migration tool

Why database migrations?

• https://flywaydb.org/getstarted/why

How Flyway works

• https://flywaydb.org/getstarted/how

Concepts

Migrations

• With Flyway all changes to the database are called migrations.
• Migrations can be either versioned or repeatable.
• Versioned migrations come in 2 forms: regular and undo.

Versioned migrations

• have version (unique), description and checksum

Repeatable migrations

• have description and checksum (no version)

Basic Commands

• Migrate
• Clean
• Info
• Validate
• Undo
• Baseline
• Repair

Flyway Migration Tools

• Language: Can be written in
  • SQL
  • Java
• Command-line client (Java)
• Maven plugin or Gradle plugin
• Other plugins

Resources

• https://en.wikipedia.org/wiki/Flyway_(software)
• https://flywaydb.org
• https://flywaydb.org/documentation/
• https://flywaydb.org/getstarted/how