Automate your database changes with continuous integration and automated deployment

Download 28-day free trial

The DLM Automation Suite plugs in to the build and release management tools you use for application development, so you can also set up continuous delivery for your databases.

It gives you a fast, reliable way to test and deploy your SQL Server database changes and a single set of development techniques that cover application and database.

You can ship updates to your customers whenever you choose, and you get the review steps and drift monitoring you need to make sure your deployments are safe for production.

Take your next steps towards a truly agile Database Lifecycle Management process today, with a 28-day free trial.

Download 28-day free trial

Pricing information

$1,795

Buy now

What our customers are saying

How the DLM Automation Suite improves your SQL Server development 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, with SQL CI.

  • Validate database structure, behavior, and deployment: SQL CI checks the structure of your database, confirms your database changes can be deployed, and runs unit tests with realistic data from the SQL Data Generator command line.
  • Build, test, and package in one process: on each check-in, or whenever you set it to run, SQL CI runs a CI process for your database with four steps – Build, Test, Sync, Publish. At the end, you have a tested NuGet package ready to use in your continuous integration or release management tool.
  • Document changes automatically: run the SQL Doc command line as an optional extra step in your CI process to update your database documentation whenever you make changes.

Find out more about SQL CI


Set up safe database automation with built-in review steps

Ship changes to your customers more frequently, cut out human error at deployment, and help your operations team ensure changes are production-ready, all from SQL Release.

  • Automate production deployments: generate and test SQL scripts that safely automate database deployments, for use in your favorite CI or release management tool.
  • Built-in review steps: DBAs and ops teams get a full rundown of SQL Server changes, including a summary, a diff report, and warnings about any potential data loss.

Find out more about SQL Release


dlm-dashboard

Track changes to your database with real-time schema monitoring

Monitor database schemas, see a record of schema changes and be alerted to database drift, with DLM Dashboard.

  • Make sure what you released is still what you're running: if something's changed since your last deployment, find out exactly what changed and if you need to redeploy.
  • Review a full audit history: get a full history of schema changes, with line-by-line differences, and details of who made the changes and when.
  • Get email alerts about unexpected changes: whenever your databases drift, you get an instant email with full details of the change and who made it.

Work with the infrastructure you use to build and deploy your applications

SQL CI and SQL Release integrate with the build and release management tools you use for your application, so you can test and deploy your database too. You don’t have to change the way you work and you get more from your development infrastructure.

We've created a range of plugins to help you set up continuous integration and automated deployment for your database. The Suite also works with any build or release system that can run command line tools or PowerShell. Find out more on our add-ons page.


Built with SQL Compare – used by 71% of the Fortune 100

The DLM Automation Suite takes care of your database automation using the world’s most trusted technology for SQL Server database changes: the SQL Compare engine.

  • Industry-standard technology: 71% of the Fortune 100 and 30,000 other organizations use SQL Compare. It’s the industry standard for comparing, syncing, and deploying SQL Server databases.
  • 14 years of real world testing: for 14 years, thousands of developers and DBAs have relied on SQL Compare and SQL Data Compare to make changes to their databases. You can count on efficient deployments with zero errors.

What's included in the DLM Automation Suite?

Automate your database changes with continuous integration and release management

Build more complex deployments using the power of Redgate command line tooling

SQL Data Compare command line

Compare and synchronize SQL Server database contents from the command line

SQL Compare command line

Compare and synchronize SQL Server database schemas from the command line

SQL Data Generator command line

Generate realistic test data fast, based on column and table names, from the command line

SQL Doc command line

Automatically generate database documentation from the command line

SQL Packager command line

Package database updates as an .exe file, from the command line

Track changes to your database schema with DLM Dashboard

Schema Monitoring

Be the first to know when any of your database schemas change

Works best with the SQL Developer Suite

The SQL Developer Suite includes SQL Source Control, a plugin that lets you use your version control system with your database. Database version control is the first step in managing your database lifecycle proactively.

The Suite also contains seven other tools that speed up development and help with manual change management. If you’re taking your first steps in Database Lifecycle Management, or want extra ways to help your development team work faster, the SQL Developer Suite is the best place to start.

Find out more on the SQL Developer Suite pages.

sql-developer-suite-hero

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 SQL CI.

Read the whitepaper (PDF)

7 Steps to Build a Database Deployment Pipeline with Redgate and TeamCity

Continuous delivery for databases brings speed, efficiency, and predictability to your release cycle, by automating database deployments across a pipeline. Setting-up version control, CI, and automated release management can provide you with a steadier stream of reliable releases.

In this practical demo, Alex Yates, Pre-Sales Engineer at Redgate, will show you how to set up continuous delivery for your SQL databases using TeamCity, Redgate tools, and Octopus Deploy. You’ll learn best practices for continuous integration, continuous delivery, and automated deployments to set up your own pipeline.

Watch fullscreen video

"The tools have given us the ability to be a lot more productive, and to save a hell of a lot of time... They allow us to have a huge amount of confidence in this major release." Neil Jellis - Technical Lead, Tissue Typing Systems

Find out how Tissue Typing Systems came to trust their database deployments after switching to Redgate’s DLM tools.

Read the case study (PDF)

Frequently asked questions

How is the DLM Automation Suite licensed?

The DLM Automation Suite is intended for team use. A license for the Automation Suite lets you install each tool the appropriate 'agent' for that tool.

Typically, this means using SQL CI on a build agent, or using SQL Release with a delivery agent or an Octopus Deploy 'tentacle'. In addition, this covers, for example, running the SQL Compare Pro command line from a scheduled task for use by a team.

How many DLM Automation Suite licenses do I need?

One DLM Automation Suite license enables you to use each tool on the appropriate 'agent' for that tool. The number of target databases doesn't affect the number of licenses required.

If you plan to run the same tool on more than one build agent or more than one release agent, you need multiple licenses of the DLM Automation Suite. For example, if you installed SQL Release for use by Octopus Deploy tentacles on four different machines, you would require four DLM Automation Suite licenses.

Both the SQL Developer Suite and the DLM Automation Suite include the SQL Compare command line. Which suite do I need?

If you're a sole user working with the SQL Compare command line, all you need is the SQL Developer Suite under its per user licensing. This is true even if you're using the SQL Compare command line on your desktop machine and, for example, a laptop.

If you're part of a team using the command line and you're automating continuous integration or release management, use the DLM Automation Suite. The DLM Automation Suite licensing is better suited to team working, plus the suite includes tools that simplify and enhance the Database Lifecycle Management process. These tools include DLM Dashboard, SQL CI, and SQL Release.

Do I need to own a SQL Developer Suite license to use the DLM Automation Suite?

We recommend you do so you can use SQL Source Control. The tools in the DLM Automation Suite work best if each member of the team has their own user license for Redgate's SQL Source Control, which is available as part of the SQL Developer Suite. Getting your database under version control is the first step in successful Database Lifecycle Management.

Worked example

One build agent, one release agent

Tom, a SQL Server developer at a pharmaceutical company, uses the command line in SQL Compare Pro for some basic compare and sync tasks that don't involve a build server.

Tom's team has recently put a continuous delivery process in place, including both continuous integration and release management for the database. Redgate's SQL CI executes an automated build and test process (using the SQL Compare command line) on every check-in to SQL Source Control. SQL Release, which runs on a different machine, runs an automated deployment process using the NuGet package created by SQL CI.

The company bought a 5-user SQL Developer Suite license for Tom and the other four in his team, so they can use SQL Compare Pro for manual day-to-day compare and sync tasks, and SQL Source Control to version control their databases. They also bought a single DLM Automation Suite license to run SQL CI on a TeamCity build agent, and SQL Release on an Octopus Deploy tentacle.

Number of users Number of agents
SQL Developer Suite 5 n/a
SQL CI (part of the DLM Automation Suite) n/a 1
SQL Release (part of the DLM Automation Suite) n/a 1
Total licenses for the SQL Developer Suite 5 n/a
Total licenses for the DLM Automation Suite n/a 1
Cost per Suite $7,180 $1,795
Total cost $8,975

Deploy to multiple databases

Dave is a Development Manager at a financial institution, looking after a team of 10 SQL Server developers. Each team member uses SQL Source Control to version control their databases. They're using SQL CI on their build server to automatically test and integrate version-controlled changes once a day. SQL Release, running on an Octopus Deploy tentacle, deploys changes to five target databases.

Dave bought a 10-user license for the SQL Developer Suite and a single license for the DLM Automation Suite, covering SQL CI running on one agent and SQL Release on another. The DLM Automation Suite is licensed per agent, so the number of target databases doesn't affect the number of licenses required. The agent also does not need to run on the same machine as the database. The Suite needs to be able to connect to the target databases from its location.

Number of users Number of agents
SQL Developer Suite 10 n/a
SQL CI (part of the DLM Automation Suite) n/a 1
SQL Release (part of the DLM Automation Suite) n/a 1
Total licenses for the SQL Developer Suite 10 n/a
Total licenses for the DLM Automation Suite n/a 1
Cost per Suite $12,565 $1,795
Total cost $14,360

Isolated environments between firewalls

Chris works in a team of 10. He and his colleagues all use SQL Prompt for code completion in SQL Server Management Studio. They've also got their databases under version control.

The team uses SQL CI on their continuous integration server to build, test, and package their database changes alongside their application code.

The package built by SQL CI is picked up by SQL Release, ready for deployment. Chris' team has three isolated environments between firewalls, and has installed SQL Release and Octopus Deploy tentacles on machines in each of the three environments, to deploy database changes to all target databases.

Chris bought a 10-user license of the SQL Developer Suite to cover SQL Prompt and SQL Source Control for the team. In addition, he bought a 3-agent license of the DLM Automation Suite, covering SQL CI on the continuous integration server and SQL Release for the three deployment targets.

Number of users Number of agents
SQL Developer Suite 10 n/a
SQL CI (part of the DLM Automation Suite) n/a 1
SQL Release (part of the DLM Automation Suite) n/a 3
Total licenses for the SQL Developer Suite 10 n/a
Total licenses for the DLM Automation Suite n/a 3
Cost per Suite $12,565 $5,385
Total cost $17,950