CI Tools and Best Practices in the Cloud

Continuous Integration

Subscribe to Continuous Integration: eMailAlertsEmail Alerts newslettersWeekly Newsletters
Get Continuous Integration: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Continuous Integration Authors: Jason Bloomberg, Yeshim Deniz, Elizabeth White, Pat Romanski, Liz McMillan

Related Topics: Apache Web Server Journal, Continuous Integration

Apache Web Server: Article

ThoughtWorks Releases Open Source Database Tool

Using dbdeploy As Part Of An Automated Build Empowers Developers To Write And Test Their Own Database Refactorings

ThoughtWorks announced the release of dbdeploy . An open source tool for developers and database administrators (DBAs), dbdeploy is a simple solution to the problem of managing and deploying database refactorings to development, quality assurance (QA), user acceptance testing (UAT) and production environments.

dbdeploy has been created by a team of ThoughtWorks professionals based on their findings during recent client engagements. The tool evolved from a number of projects where its use, in conjunction with best practices such as continuous integration and automated builds, proved effective. dbdeploy has already been successfully implemented in internet service providers (ISPs) , the publishing and leasing sectors and a global sales and marketing organisation.

Nick Ashley, Consultant at ThoughtWorks explains the benefits of dbdeploy: “Getting database refactorings out of the development environment and pushed through to production can be a complex manual process that is prone to error. dbdeploy simplifies this process by automatically running database refactorings with each build. Using dbdeploy as part of an automated build empowers developers to write and test their own database refactorings, at the same time freeing up the DBA to work on more challenging issues. Another significant benefit of using dbdeploy is that database refactorings need only be written once - the tool then takes the strain and knows whether specific refactorings need to be applied to specific databases.”

Ashley continues: “When dbdeploy was used at a leading UK ISP it saved in the region of 3 days of effort per release. Prior to its introduction, a developer would need to gather together, test and fix the database refactorings to be shipped with the release. The need for this task was eliminated with the introduction of dbdeploy. Now that dbdeploy has been open sourced these benefits can be realised by other organisations at no cost.”

dbdeploy is written in Java and integrates with the Apache Ant build tool supporting Oracle, MS SQL Server, Sybase and Hypersonic SQL databases. A .Net port of the tool is in progress, which will be geared towards inclusion in .Net projects for use within Nant and MSBuild. The ThoughtWorks dbdeploy team included Graham Tackley, Nick Ashley and Sam Newman.

More Stories By Open Source News

Enterprise Open Source News Desk trawls the fast-growing world of Professional Open Source for business-relevant items of news, opinion, and insight.

Comments (1)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.