Posted 26 Nov 2019 by Nathan Voxland
TL;DR: With the release of Liquibase 3.8.2, Liquibase Pro users with workloads on PostgreSQL and DB2 are now able to capture and export Stored Logic objects. These Stored Logic objects will now export into local directories and files, making them easier to organize and manage. This release also includes several bug fixes for Liquibase Community and Pro.
The ability to snapshot Stored Logic for Postgres and DB2 allows users to get a static view of the database at a particular point in time and is useful for reporting and safeguarding data by comparing databases (performing diffs) to find differences. Liquibase Pro users will also now be able to include Stored Logic changeSets in changelogs generated through the diffChangeLog and generateChangeLog command. Users can reverse engineer Stored Logic changes using generateChangeLog, snapshot, diff, and diffChangeLog commands.
Stored Logic objects include:
If Stored Logic code gets written directly into the Liquibase changelog, the file can get very cluttered. Additionally, Stored Logic code is often formatted and this formatting can be lost when it’s written to the changelog. Liquibase Pro eliminates the clutter by making the changelog more concise and readable, allowing users to maintain formatting by outputting the Stored Logic code via external files that can be referenced by the changelog. SQL files are organized in directories by object type, making them easy to find.
Try Liquibase Pro
Take advantage of all of these new Liquibase Pro features with a free 14-day trial. In addition to enhanced features, Liquibase Pro users also receive experienced guidance and fast troubleshooting from our excellent Liquibase support team.
For both Liquibase Community and Liquibase Pro users, the following bugs were fixed in version 3.8.2:
We have opened our Liquibase Community Survey! This is your opportunity to help us concentrate on the features and functionality that you want to see added to Liquibase.
It only takes about 5 minutes and the first 1000 responses receive a gift card. Handy for the holidays!