Over a million developers have joined DZone.

New Database Management Plugin from Datical

DZone's Guide to

New Database Management Plugin from Datical

· Java Zone
Free Resource

Just released, a free O’Reilly book on Reactive Microsystems: The Evolution of Microservices at Scale. Brought to you in partnership with Lightbend.

One of the riskiest and most manual parts of a deployment is updating the database schema. We’ve argued for years that you should automate these processes. The most common first step in that direction is to take the SQL scripts you’ve been using and treat them as incremental versions in IBM UrbanCode Deploy. That works, and the plugins for common databases like Oracle and Microsoft SQL Server make it easier.

We are big believers in capturing a “version” of the database as a whole that you can point at your prior database and it will figure out what changes are missing and make them in the correct order. Long time users of UrbanCode products will know that upgrades don’t come with instructions for the DBA. The installer just figures it out. Some of our customers are using the same utility and so there’s a plugin available for that.

Today, the database deployment problem is becoming increasingly common as organizations are getting the rest of their stack automated. The DBA’s are becoming a big bottleneck. Not surprisingly, there are some new solutions in this space. One that builds on the popular open-source LiquidBase is provided by Datical with a focus on enterprise capabilities and ease of use. There’s some pretty cool stuff in there, and now they’ve introduced a plugin for UrbanCode Deploy.

You should check out their demo of the integration:

Strategies and techniques for building scalable and resilient microservices to refactor a monolithic application step-by-step, a free O'Reilly book. Brought to you in partnership with Lightbend.


Published at DZone with permission of Eric Minick, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}