Spring DB Migration

• Flyway
• Liquibase

Flyway

• Versioned Migrations: V<version>__<description>.sql
• Undo Migrations (僅 Pro 版本支援): U<version>__<description>.sql

• Repeatable Migrations: R__<description>.sql

VCS (版本控制結構)

路徑: src/main/resources/db/migration

• V1__initialising_sechma.sql
• V2__add_category_to_book.sql
• V3__add_published_date_to_book.sql
• …

Schema History Table (歷史表結構)

  classDiagram
    class flyway_schema_history{
        installed_rank
        version
        description
        type
        script
        checksum
        installed_by
        installed_on
        execution_time
        success
    }

Commands (常用命令)

Spring Properties (屬性配置)