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 .

Maven Commands

Generate Change Log

Exclude Data

-Pmyq,dev,log      # mysql , development
-Pora,pro,log      # oracle, production
-Pdev,log          # h2    , development
-Plog              # h2    , development

Include Data

-Pdat,myq,dev,log   # mysql , development
-Pdat,ora,pro,log   # oracle, production
-Pdat,dev,log       # h2    , development
-Pdat,log           # h2    , development

Profiles

Diff 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

Context Profiles

Porfile	Context	Notes
dev	Development	For Development Environment
qac	Quality Assurance & Control	For QA Environment
uat	User Acceptance Test	For UAT Environment
pro	Production	For Production Environment
default	Development	For Development Environment

Commands Profiles

Porfile	Commands	Notes
log	generateChangeLog	Generate Change Log
upd	update	Migration/Update Database
dif	diff	Generate Database Diff Change Log
syn	changelogSync	Synchronize Database with Change Log
rol	rollback	Rollback Database to the Date/Tag
del	dropAll	Empty/Clean Database
default	generateChangeLog	Generate Change Log

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