Liquibase: Difference between revisions
Jump to navigation
Jump to search
Line 43: | Line 43: | ||
|- | |- | ||
| default || MySQL || mysql || jdbc:mysql || No Issues | | default || MySQL || mysql || jdbc:mysql || No Issues | ||
|} | |||
=== Context Profiles === | |||
{| class="wikitable sortable" | |||
|- | |||
! 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 === | |||
{| class="wikitable sortable" | |||
|- | |||
! 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 | |||
|} | |} | ||
Revision as of 01:55, 19 September 2018
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 |
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