Top of the Line Database Release Management Tool

We group database SQL changes by ticket and release, performing managed deployment across environments. The SQL is entered into the GUI tool. Once the scripts are entered, everything is checked into Git using the plugin. Once in Git, Jenkins stages the artifacts to be deployed by Ansible AAP using Hammer libraries provided by Liquibase. Using this we can determine which tickets have been deployed, which need to be deployed, and which may have been modified after initial deployment through checksum comparison.

Instead of blindly running scripts and manually keeping track of failures, Liquibase allows us to mark off the change tickets that completed and focus on the failures that show as undeployed. By using tag matching, we can set dependency orders of what goes into each release. We've been using different incarnations of the tool for at least 8 years, and we really aren't aware of another tool that organizes database deployments so well.