Once you have run your first update, you can go through the entire developer workflow from beginning to end.
Add new changesets to the changelog
On your local development machine, add new changeset(s) to your changelog.
Apply changes to the developer database
liquibase update to apply the changes to the developer database. Iterate until you are happy with the final state.
Understand database changes before saving and applying them
It is always best practice to understand the changes BEFORE saving and applying them to the changelog… especially if someone else edited or created the changelog.
Running the following command to see if there are changesets that have no been applied to the integration database:
liquibase --url=jdbc:h2:tcp://localhost:9090/mem:integration status --verbose
Check your SQL
Run the following command to check the SQL before applying updates:
liquibase --url=jdbc:h2:tcp://localhost:9090/mem:integration updateSQL
You can also run a diff command to compare the changes before saving and applying them:
liquibase --referenceUrl=jdbc:h2:tcp://localhost:9090/mem:integration --referenceUsername dbuser --referencePassword letmein diff
Save to source control
Save your changelog to source control when you are happy with the changes that will be applied.
Apply the new changesets
Apply the new changesets:
liquibase --url=jdbc:h2:tcp://localhost:9090/mem:integration update
To see that all changes have been applied to the integrations database, rerun the following commands:
Now that you have a feel for Liquibase against your sample database, you can try it against your standard databases.
Just add your database’s jdbc drivers to the lib directory in the Liquibase install directory and update the url, username, and password fields in the liquibase.properties file.
Also, check the documentation associated with your specific database to locate the correct URL format and download the driver jar. Then, use the Liquibase developer workflow to make changes against your own database.
Next up: Get a free trial of Liquibase Pro