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.
Also in DLM Automation
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
Do not use a scalar user-defined function (UDF) in a JOIN condition, WHERE search condition, or in a SELECT list, unless the function is schema-bound. Scalar UDFs are often used without a parameter to...
Also in Product learning
Snippets are a great feature of SQL Prompt. They save coding time, and introduce standards and consistency to the way you build code modules. They have multiple replacement points (placeholders) for p...
Also about continuous integration
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
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...