Generate Update Scripts with Liquibase

Owned by Former user (Deleted)
Last updated: Nov 25, 2014
1 min read

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

    # 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.

    For example, 

    cp liquibase.properties kfs/work/db/upgrades/5.2_5.3/db

  3. Ensure that the liquibase jar file is available

    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

    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.