Liquibase
Path Settings
export MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$MYSQL_HOME/bin
Configuration
mkdir -p $HOME/.chorke/etc/liquibase/init
cp ./src/test/resources/liquibase/*.properties $HOME/.chorke/etc/liquibase/init
cd $HOME/.chorke/etc/liquibase/init
explorer .
Profiles
Diff Types Profiles
| Porfile | Note | Diff Types |
|---|---|---|
| dat | Include Data | tables,views,columns,indexes,foreignkeys,primarykeys,uniqueconstraints,data |
| default | Exclude Data | tables,views,columns,indexes,foreignkeys,primarykeys,uniqueconstraints |
Database Profiles
| Porfile | Database | Type | JDBC | Notes |
|---|---|---|---|---|
| der | Apache Derby | derby | jdbc:derby | No Issues |
| h2d | H2 | h2 | jdbc:h2:file | No Issues |
| hsq | HSQL | hsqldb | jdbc:hsqldb:file | No Issues |
| mys | MySQL | mysql | jdbc:mysql | No Issues |
| ora | Oracle | oracle | jdbc:oracle:thin | 11g driver for diff with AL32UTF8 or AL16UTF16 |
| pos | PostgreSQL | postgresql | jdbc:postgresql | 8.2+ for drop all database objects |
| default | MySQL | mysql | jdbc:mysql | No Issues |
Migration
mvn clean install -Pdev,log
mvn clean install -Pdev,syn
mvn clean install -Pdev,upd
mvn clean install -Pdif
mvn clean install -Pqac,syn
mvn clean install -Pqac,upd
mvn clean install -Puat,syn
mvn clean install -Puat,upd
mvn clean install -Ppro,syn
mvn clean install -Ppro,upd
mvn clean install -Ppro,del
mvn clean install -Ppro,rol -chorke.tag=20180806