Over a million developers have joined DZone.

How to Extend IBM Urbancode Deploy's Automation Capabilities to the Database

A database continuous delivery solution provides enforced version control and reliable deployment automation for the database.

· DevOps Zone

The DevOps zone is brought to you in partnership with Sonatype Nexus. The Nexus suite helps scale your DevOps delivery with continuous component intelligence integrated into development tools, including Eclipse, IntelliJ, Jenkins, Bamboo, SonarQube and more. Schedule a demo today

In the ever-competitive software space, businesses are constantly striving to make more changes faster, without becoming exposed to excessive risk.

IBM UrbanCode Deploy orchestrates and automates the deployment of applications, middleware configurations, and database changes into development, test, and production environments.
There is a need to safely include the database component within the existing deployment processes of the application tiers, from building (generating upgrade SQL scripts), to verifying that the environments are identical (no drifts), to deploying (executing the planned upgrade SQL scripts), while documenting the changes.

To accomplish this, you need a database continuous delivery solution that provides enforced version control and reliable deployment automation for the database. A common continuous delivery process consists of various applicative and database components. DBmaestro TeamWork offers an integration with IBM UrbanCode Deploy by enhancing it with the required functionality to include database build & deployment tasks.

This post covers the integration of UrbanCode Deploy with DBmaestro.

How to

After completing the installation of the DBmaestro Teamwork plugin, get started by creating a process. First, apply a label on the source environment. DBmaestro Teamwork will automatically generate the database deployment script. Then, apply a label on the target environment. It will be used as backup.

Enable deployment mode, which allows executions of the script and modification of the objects. Next, execute the script using an SQL plugin or any other tool. After executing the script, exit the deployment mode. At this point, DBmaestro Teamwork identifies the changed objects and marks them as being checked out.

Check on the objects and ensure the repository is being updated to have the same definition as the database. Apply a label on the target after deployment is completed successfully. This will be used as a baseline for the next execution of the process.

When the process is completed, it can be integrated with the rest of the application automation. DBmaestro Teamwork will pause the automation process in case of conflicts. These conflicts can arise as a result of working in parallel mode or critical fix release.

Once your integration is set up, explore how you can bring complete automation to your delivery pipeline, supporting your Continuous Delivery or DevOps initiatives.

Join a free online demo here.

The DevOps zone is brought to you in partnership with Sonatype Nexus. Use the Nexus Suite to automate your software supply chain and ensure you're using the highest quality open source components at every step of the development lifecycle. Get Nexus today

urbancode deploy,database automation

Published at DZone with permission of Yaniv Yehuda, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

Please provide a valid email address.

Thanks for subscribing!

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

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

{{ parent.tldr }}

{{ parent.urlSource.name }}