Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Current »

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.

 

  • No labels