3 December 2015
3 December 2015

DLM Automation add-ons

Many software teams are already integrating their application code but haven’t yet brought the continuous integration discipline to their database development. With DLM Automation, you can extend that process by plugging into third party tools commonly used for application development. It’s now even easier to find the add-on you need for your build or release system.

The idea of database continuous integration is still fairly new, despite continuous delivery processes being increasingly commonplace for managing applications. The particular challenge databases present is that production has existing mission-critical data that must be protected. You can’t simply overwrite yesterday’s data when you deploy database changes as you can with application code. So to test the deployment of a new database version in an automated process, you need a deployment process that preserves the state of the data.  

That’s where DLM Automation comes in.  The product contains two core tools that cater for the specific requirements of building, testing, and deploying database changes: SQL CI and SQL Release.  Both tools plug into third party build and release systems to enable you to automate the deployment of database changes alongside your application code. You can continue to use the systems you’re familiar with and you get more value out of your existing infrastructure.

When we originally launched DLM Automation earlier this year, add-ons were included for Microsoft Team Foundation Server, TeamCity and Octopus Deploy. At the time, our surveys were showing us these were the systems our customers most commonly used for building and releasing applications. Since then, we’ve heard from more and more customers who are using or looking to adopt different tools and we’ve received demand for add-ons for other systems.

As a result, we’ve developed new plugins for Jenkins, Bamboo, and Visual Studio Team Services, and they are all now available via a single add-ons page. We’ve also taken the decision to remove the existing plugins from DLM Automation and make them accessible via the same page. Once you download DLM Automation, you will be directed to this page to choose the add-on you need and access the appropriate documentation.  

If a plugin for the system you’re using isn’t yet available, you can still integrate with DLM Automation tools using the command line or PowerShell. And we’d love to hear from you to help inform decisions about whether there are other plugins we should develop next or new features we could add to the existing add-ons.  

Tools in this post

DLM Automation

Continuous integration and automated deployments for your SQL Server database.

Find out more

Share this post.

Share on FacebookShare on Google+Share on LinkedInTweet about this on Twitter

Related posts

Also in DLM Automation

Unearthing Bad Deployments with SQL Monitor and Redgate's Database DevOps Tools

Sudden performance issues in SQL Server can have many causes, ranging all the way from malfunctioning hardware, through to simple misconfiguration, or perhaps just end users doing things they shouldn'...

Also in Hub

Finding code smells using SQL Prompt: TOP without ORDER BY in a SELECT statement

Using TOP in a SELECT statement without a subsequent ORDER BY clause is legal in SQL Server, but meaningless because asking for the TOP 10 rows implies that the data is guaranteed to be in a certain o...

Also in Product learning

Choosing Between Table Variables and Temporary Tables

People can, and do, argue a great deal about the relative merits of table variables and temporary tables. Sometimes, as when writing functions, you have no choice; but when you do you’ll find that b...

Also about continuous integration

Database CI with Redgate DLM Automation, PowerShell and Jenkins

While the practice of Continuous Integration (CI) started with application code, you can apply the same principles to databases. Database CI is the process by which we build, test and deploy the datab...

Also about DLM Automation

Database automation made easier

Last week saw the release of DLM Automation - a new improved version of our database automation offering. So what’s changed?

DLM Automation combines all the functionality of its predecessors, SQL C...