197. Spring Boot 2.0数据库迁移:Liquibase
说明:
(1)Spring Boot 版本:2.0.0.RELEASE
(2)Liquibase版本:3.5.5
前言:
在上一节中spring boot使用了1.5.12.RELEASE,这里我们要看看2.0.0.RELEASE的一个使用情况。大体的思路和上一篇是使用的,这里我们在上一篇文章的基础上进行调整。
一、版本说明
这里的Spring Boot版本使用的是2.0.0.RELEASE,Liquibase这里还是3.5.5的版本的。
二、准备工作
在上一篇的基础上,我们首先要修改下配置文件application.properties,因为在2.0.0配置路径的配置项修改了,如下配置:
spring.liquibase.change-log= classpath:/db/changelog/db.changelog-master.sql
当1.5.12版本是如下配置:
liquibase.change-log= classpath:/db/changelog/db.changelog-master.sql
这里由于Liquibase的版本还是3.5.5版本的,所以不需要数据库的表结构信息就可以测试了。
三、测试
到这里就可以运行测试了,顺利的话, 一切就会如之前一样的效果了。
四、配置说明
对于2.x的版本,Liquibase的配置加上了spring的前缀,如下配置:
# LIQUIBASE (LiquibaseProperties)
spring.liquibase.change-log=classpath:/db/changelog/db.changelog-master.yaml # Change log configuration path.
spring.liquibase.check-change-log-location=true # Whether to check that the change log location exists.
spring.liquibase.contexts= # Comma-separated list of runtime contexts to use.
spring.liquibase.default-schema= # Default database schema.
spring.liquibase.drop-first=false # Whether to first drop the database schema.
spring.liquibase.enabled=true # Whether to enable Liquibase support.
spring.liquibase.labels= # Comma-separated list of runtime labels to use.
spring.liquibase.parameters.*= # Change log parameters.
spring.liquibase.password= # Login password of the database to migrate.
spring.liquibase.rollback-file= # File to which rollback SQL is written when an update is performed.
spring.liquibase.url= # JDBC URL of the database to migrate. If not set, the primary configured data source is used.
spring.liquibase.user= # Login user of the database to migrate.
Spring Boot 1.x的版本的配置如下:
# LIQUIBASE (LiquibaseProperties)
liquibase.change-log=classpath:/db/changelog/db.changelog-master.yaml # Change log configuration path.
liquibase.check-change-log-location=true # Check the change log location exists.
liquibase.contexts= # Comma-separated list of runtime contexts to use.
liquibase.default-schema= # Default database schema.
liquibase.drop-first=false # Drop the database schema first.
liquibase.enabled=true # Enable liquibase support.
liquibase.labels= # Comma-separated list of runtime labels to use.
liquibase.parameters.*= # Change log parameters.
liquibase.password= # Login password of the database to migrate.
liquibase.rollback-file= # File to which rollback SQL will be written when an update is performed.
liquibase.url= # JDBC url of the database to migrate. If not set, the primary configured data source is used.
liquibase.user= # Login user of the database to migrate.
购买完整视频,请前往:http://www.mark-to-win.com/TeacherV2.html?id=287