Liquibase

liquibase
.........
/workspaces/he-catalog/install/database/liquibase
cd /export/home/portal/he-frontend_prod_8080/install/database/liquibase/

##rollback

java -jar lib/liquibase-core-2.0.5.jar --changeLogFile=update.xml  rollbackSQL version_1.7.0 >> rollback.sql
-- inspect rollback.sql to make sure the database changes to be made look correct; compare rollback.sql with futureRollbackSQL.sql (they should be equivalent); have DBA review if needed
java -jar lib/liquibase-core-2.0.5.jar --changeLogFile=update.xml rollback version_1.7.0 >> rollback.log



##install

java -jar lib/liquibase-core-2.0.5.jar --changeLogFile=update.xml  futureRollbackSQL >> futureRollbackSQL.sql
java -jar lib/liquibase-core-2.0.5.jar --changeLogFile=update.xml updateSQL >> updateSQL.sql
-- inspect updateSQL.sql to make sure the database changes to be made look correct; have DBA review if needed
java -jar lib/liquibase-core-2.0.5.jar --changeLogFile=update.xml update >> update.log