Continuous integration and automated deployments for your SQL Server database

Download 28-day free trial

DLM Automation works with your CI server and release management system, so you test, build, and release your database alongside your application code.

You get a fast, reliable way to check and deploy your changes and a single set of development techniques that cover your application and database.

You can minimize the risk of database deployment problems, and free developers from time-consuming change management tasks, like sorting out deployment scripts.

With built-in review steps, you can guarantee your releases are production ready, and deliver updates to your customers as frequently as you like.

Download 28-day free trial

Available as part of the SQL Toolbelt

Find out more about the SQL Toolbelt

DLM Automation works to automate your builds and deployments using the database code you check in with SQL Source Control.

Each member of your team will require a SQL Toolbelt license to automate builds and deployments using SQL Source Control and DLM Automation.

The SQL Toolbelt costs $2,745 per user.

What our customers are saying

How DLM Automation improves your database development and deployment process:

Catch bugs and speed up database development with continuous integration

Cut the risk of deployment problems, and take manual change management off your developers’ hands.

  • Verify the structure of your database, confirm your changes can be deployed, and test your work with realistic data.
  • Create tested NuGet packages that you can deploy with your continuous integration or release management system, all in one process.
  • Check how many statements in your database code are executed when you run your tests using DLM Automation with SQL Cover.

Automate your deployments safely with built-in review steps

Ship changes to your customers frequently, cut out human error at deployment, and help your operations team check changes are production-ready.

  • Generate SQL scripts that safely automate database deployment, for use with your CI or release management system.
  • Get a full rundown of SQL Server changes, including a summary, a diff report, and warnings about any potential data loss.

Works with the system you use to build and deploy your applications

DLM Automation works with whatever build or release tools you use for your application. You don’t have to change the way you work and you’ll get more from your development infrastructure.

  • Add-ons are available for TeamCity, Team Foundation Server, Visual Studio Team Services, Jenkins, Bamboo, Octopus Deploy, and MSBuild scripts.
  • Work with other build and release systems or customize your deployment workflow using DLM Automation’s pre-written cmdlets.

Works with other tools in the SQL Toolbelt to extend your CI process

  • Trigger an automated build when you check changes into version control with SQL Source Control.
  • Set up automated testing as part of your CI process by creating tSQLt unit tests with SQL Test.
  • Test your changes with realistic data, based on your column and table names, with SQL Data Generator.
  • Get up to date documentation as part of your CI process with SQL Doc – ideal for compliance with SOX and other legislation.
  • Track your builds through your database environments with DLM Dashboard

Key benefits

Speed up your testing cycle

DLM Automation syncs your test and development environments automatically, so test is always up to date and your testing cycle becomes much faster.

If you have tSQLt tests (such as static analysis tests, unit tests, or integration tests), DLM Automation runs them for you as part of SQL Server continuous integration.

Get the exact script you need for SQL release automation

When you’re ready to deploy, DLM Automation generates a script to update your databases. You can run it straight away, save it for review, or add it to your deployment tool. As a final check, you can run it first in pre-production before using it to deploy to other environments.

Review and approve database changes in your release tool

If your DBA or Ops team like to review changes before they go live, no problem. DLM Automation includes a review step that integrates with your release management tool. You can check the script, get a full report on the differences, and warnings if there’s any chance of data loss.

Protect against database drift and inconsistency

Before you deploy to production, DLM Automation checks your schema hasn’t drifted since your deployment script was generated. This cuts out errors caused by inconsistencies or unexpected changes. After you’ve deployed, it runs a final validation check to make sure your changes were successful.

Deploy static data and migration scripts

Artifacts built with DLM Automation have full support for data changes. You can include static data and migration scripts that specify how to deploy complex database changes, such as table splits.

Use standard Microsoft NuGet packages to test and deploy

DLM Automation uses Microsoft NuGet packages to test and publish your database. The NuGet package manager is free and open-source, so there are no hidden costs. And because it comes from Microsoft, there’s first-class support for .NET and SQL Server.


Resources

Continuous integration for databases using Redgate tools

A nuts-and-bolts look at the advantages of continuous integration for databases, and how to include SQL Server databases in your build automation process using DLM Automation.

Read the whitepaper (PDF)

Adopting Redgate Database Lifecycle Management (DLM) at Albumprinter

Learn how Redgate DLM helped Albumprinter move a database that supports 25 different applications out of manual development and into a continuous delivery process.

Read the case study (PDF)

"We can now do live database deployments at the push of a button"

The challenge for many businesses is how to deploy database updates as easily as application updates. Dutch company Nmbrs® turned to Redgate’s DLM tools and found it simpler than they imagined.

As Luis Abreu, Nmbrs® CTO, says:

"The productivity of the team has improved dramatically. We were doing one database update a week, which took almost a full day. Now it takes ten minutes. We can spend the extra time we’ve gained developing new features."

Read the case study (PDF)

Redgate DLM Demo (with Git, TFS Build & Microsoft Release Management)

Microsoft SQL Server MVPs, Grant Fritchey and Steve Jones, talk about how Redgate’s Database Lifecycle Management (DLM) solution works to improve your database development and deployment processes.

You'll see how to:

  • Version control your databases from SSMS to track and understand changes
  • Include your database in your Continuous Integration process to get quick feedback
  • Automate your database deployment process to have safe, reliable, repeatable deployments
  • Monitor your databases across environments to understand their versions and get notified of changes

In this webinar they showed how Redgate DLM tools plug into Git, TFS Build & Microsoft Release Management.

Watch fullscreen video

Redgate DLM Demo (with TFS, TeamCity, & Octopus Deploy)

Redgate’s Arneh Eskandari and Microsoft SQL Server MVP Grant Fritchey, talk about how Redgate’s Database Lifecycle Management (DLM) solution works to improve your database development and deployment processes.

In this webinar they showed how Redgate DLM tools plug into TFS, TeamCity & Octopus Deploy.

Watch fullscreen video

Redgate DLM Demo (with TFS, Jenkins, & Octopus Deploy)

Microsoft SQL Server MVP, Steve Jones, talks about how Redgate’s DLM (Database Lifecycle Management) solution works to improve your database development and deployment processes.

In this webinar Steve showed how these tools plug into TFS, Jenkins & Octopus Deploy.

Watch fullscreen video

Redgate DLM Demo (with SVN, TeamCity, & Octopus Deploy)

Microsoft SQL Server MVP, Steve Jones, shows how Redgate’s DLM (Database Lifecycle Management) solution works to improve your database development and deployment processes.

In this webinar Arneh & Steve showed how these tools plug into SVN, TeamCity & Octopus Deploy.

Watch fullscreen video

Redgate DLM Demo (with TFS, TFS Build, & Microsoft Release Management)

Redgate's Arneh Eskandari and Microsoft SQL Server MVP, Steve Jones, show you how Redgate's DLM solution improves your database development and deployment processes.

In this webinar Arneh & Steve showed how these tools plug into TFS, TFS Build & Microsoft Release Management.

Watch fullscreen video

Redgate DLM Demo (with Git, TFS Build & Microsoft Release Management)

Microsoft SQL Server MVP, Steve Jones, talks about how Redgate’s DLM (Database Lifecycle Management) solution works to improve your database development and deployment processes.

In this webinar Steve shows how these tools plug into Git, TeamCity and Octopus Deploy.

Watch fullscreen video