Page Comparison

How to run Liquibase to genereate update SQL for KFS upgrades.

Step-by-step guide

1. Edit the liquibase.properties file and make sure the values are valid

   Info
   # rename this to liquibase.properties when testing classpath=/kuali/drivers/ojdbc6.jar  driver=oracle.jdbc.OracleDriver url=jdbc:oracle:thin:@localhost:1525:kfsupdev username=kfs_upsnd password=<password>

2. Copy the liquibase.properties file into the specific version folder.

   Info
   For example,  cp liquibase.properties kfs/work/db/upgrades/5.2_5.3/db

3. Ensure that the liquibase jar file is available

   Info
   It is usually in the upgrades/<version> folders $ ls kfs/work/db/upgrades/5.2_5.3/liquibase* /kuali/projects/dave/kfs53/work/db/upgrades/5.2_5.3/liquibase-2.0.5.jar

4. Run liquibase from the db directory

   Info
   cd kfs/work/db/upgrades/5.2_5.3/db java -jar ../liquibase-2.0.5.jar --logLevel=debug --changeLogFile=master-data-script.xml updateSQL > updateSQLdata.sql

5. Repeat the above for each child folder (structure, data, constraint) that contains liquibase scripts.

Related articles