What are the different types of migrations in Flyway?

Beginner

Answer

Flyway supports three types of migrations:

  1. Versioned Migrations: Applied exactly once, have version numbers
    • Example: V1__Create_user_table.sql
  2. Repeatable Migrations: Applied whenever their checksum changes
    • Example: R__Update_user_view.sql
  3. Undo Migrations: Used to reverse versioned migrations
    • Example: U1__Undo_Create_user_table.sql