springcloud中使用flyway作数据迁移时要注意的问题

• pom中引用flyway的core包

        <dependency>
            <groupId>org.flywaydb</groupId>
            <artifactId>flyway-core</artifactId>
            <version>5.2.4</version>
        </dependency>

• 创建sql存放目录时要注意命名，如：db.migration，要先创建db目录再创建migration目录，因为在application.yml一般配置的是两级目录

flyway:
    baseline-on-migrate: true
    locations: classpath:/db/migration

• 如果每个微服务的resource中都有自己的db/migration，默认情况下会报

nested exception is org.flywaydb.core.api.FlywayException: Validate failed: Detected applied migration not resolved locally

这是因为通过flyway_schema_history表对本地sql文件进行连续性验证的结果，关闭验证即可。

flyway:
    baseline-on-migrate: true
    validate-on-migrate: false
    locations: classpath:/db/migration

转载于:https://my.oschina.net/jenqz/blog/3102569