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: