FlywayのサンプルをSQLiteでやってみる ref: http://qiita.com/takaki@github/items/d8831694eef6ce4da1e9

build.gradle

apply plugin: 'java'
apply plugin: "org.flywaydb.flyway"

buildscript {
    repositories {
        jcenter()
    }
    dependencies {
        classpath group: "org.flywaydb", name: "flyway-gradle-plugin", version: "4.0.3"
        classpath group: 'org.xerial', name: 'sqlite-jdbc', version: '3.8.11.2'
    }
}

repositories {
    mavenCentral()
}

flyway {
    url = "jdbc:sqlite:./target/sample.db"
}

file2.txt

$ gradle flywayMigrate 

file3.txt

$ sqlite3 target/sample.db '.schema PERSON'
CREATE TABLE PERSON (
    ID int not null,
    NAME varchar(100) not null
);

file5.txt

$ gradle flywayMigrate 

file6.txt

$ sqlite3 target/sample.db 'select * from person'
1|Axel
2|Mr. Foo
3|Ms. Bar

V1__Create_person_table.sql

create table PERSON (
    ID int not null,
    NAME varchar(100) not null
);

V2__Add_people.sql

create table PERSON (
    ID int not null,
    NAME varchar(100) not null
);