MySql to Liquibase Converter

The MySql to Liquibase Converter is intended to split up the contents of a single MySql sql file into a series of smaller files that are easier to maintain and version independently.

Installation

npm install --global mysql-liquibase-converter

Usage

  Usage: mysqlbase [options] <sqlFile> [outputLocation]

  Options:

    -h, --help              output usage information
    -V, --version           output the version number
    -d, --includeData       include table data
    -k, --tempKeys          disable and re-enable foreign keys, helps order of execution issues
    -a, --author <name>     changeset author, defaults to `converter`
    -c, --changesetId <id>  changeset id, defaults to `baseline`

Output conventions

The following describes the output and folder conventions for the liquibase converter.

root/
    migrations/                 # root folder for migrating stateful database objects
        <changesetId>/          # all scripts related to a particular changeset are grouped under here
            tables/             # table DDL scripts used for migrations go here include create/alter statements
            data/               # insert/update/delete scripts to migrate seed/reference data goes here
            support/            # supporting scripts go here, example includes scripts to disable/enable foreign keys
    source/                     # root folder for non-stateful source code
        triggers/               # source for triggers defined here
        storedprocedures/       # stored procedures here (not implemented)
        views/                  # views defined here (not implemented)
    changelog.json              # liquibase changelog file decribes the scripts and their order of execution