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

Whether you work in SQL Server Management Studio or Visual Studio, Redgate tools integrate with your existing infrastructure, enabling you to align DevOps for your applications with DevOps for your SQL Server databases. Discover true Database DevOps, brought to you in partnership with Redgate.

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.


It’s easier than you think to extend DevOps practices to SQL Server with Redgate tools. Discover how to introduce true Database DevOps, brought to you in partnership with Redgate

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

Opinions expressed by DZone contributors are their own.

THE DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

X

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

{{ parent.tldr }}

{{ parent.urlSource.name }}