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	Diff Types
dat	Include Data
default	Exclude Data

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

References

• Database-Independent Script in Liquibase
• Liquibase Migration Example
• Liquibase Documentation