Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Liquibase for Application Release Managers

DZone's Guide to

Liquibase for Application Release Managers

By adopting Liquibase, application release managers are able to know that the database change scripts Developers write, QA teams test, and the DBAs sign-off on will be automatically and consistently checked and validated every time a new release is ready to push to production. Read on for more info.

· Database Zone ·
Free Resource

Databases are better when they can run themselves. CockroachDB is a SQL database that automates scaling and recovery. Check it out here.

In the modern agile development environment, there is a lot that happens in a very short period of time. This means application release managers need to be efficient with their time while ensuring nothing falls through the cracks. The database updates that go along with each application release are just as important as the application code, both for deployment and for planning rollbacks.

By adopting Liquibase, application release managers are able to know that the database change scripts Developers write, QA teams test, and the DBAs sign-off on will be automatically and consistently checked and validated every time a new release is ready to push to production. In addition, Liquibase makes database rollbacks easy.

Prepare for Deployment Problems

Releases don't always go as planned, and Liquibase helps application release managers ensure contingency plans are correct before each release. As teams get closer to releasing new application updates, besides checking the updateSql output, release managers can also run futureRollbackSql which will output the SQL needed to bring a fully updated database back to the current state.

No Change is Forgotten

Liquibase tracks which changelog statements have run against each database, so release managers no longer have to manually track what statements have been run against each database and which have not.

Sanity Checks

Liquibase ships with several tools application release managers can use to: check current database state, make sure database changes are being applied correctly, and ensure that no one is sneaking in changes out of process.

  • The status and validate commands report on what changeSets have not yet been executed and checks the changelog for errors.
  • The diff command reports on differences between databases to ensure that two fully updated databases are truly identical
  • The dbdoc command generates documentation on the current database structure and its changes over time

Enterprise Features With Datical

If your application release teams determine their needs extend beyond all the great capabilities Liquibase offers, check out Datical. Datical builds upon Liquibase and lets release managers:

More information on Datical DB can be found here.


Databases should be easy to deploy, easy to use, and easy to scale. If you agree, you should check out CockroachDB, a scalable SQL database built for businesses of every size. Check it out here. 

Topics:
liquibase ,application release automation ,database ,relational database ,database schema ,database changes ,database change management

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}