Quick Note: liquibase – agile database toola

Liquibase

Liquibase Documentation

For Oracle, use the latest JDBC Driver:  ojbc7.jar

 cd C:toolsliquibase-3.1.1-bin
 liquibase --classpath=ojdbc7.jar --driver=oracle.jdbc.OracleDriver --url=jdbc:oracle:thin:@//SERVER:PORT/SERVICENAME --username=USERNAME--password=PASSWORD--referenceUrl=jdbc:oracle:thin:@//QASERVER:QAPORT/QASERVICENAME diff --referenceUsername=QAUSER --referencePassword=QAPASS
liquibase --classpath=ojdbc7.jar --driver=oracle.jdbc.OracleDriver --url=jdbc:oracle:thin:@//SERVERNAME:PORT/EORDD --username=USERNAME--password=PASSWORD--changeLogFile=change.xml dbDoc docs

Liquibase is a very cool utility for migrating and managing database changes between platforms.  It works well with open source database and proprietary databases like Oracle.

Written By bunkertor

Leave a Reply

Your email address will not be published. Required fields are marked *