Automate your database changes with continuous integration and release management

Download 28-day free trial

The DLM Automation Suite extends your continuous integration and release management processes to SQL Server, so you can set up continuous delivery for your databases.

It gives you a fast, reliable way to test and deploy your 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.

Visual Studio Team Foundation Build, TeamCity, CruiseControl, ThoughtWorks Go, Jenkins, Atlassian Bamboo, PowerShell, Octopus Deploy, Release Management for Visual Studio

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

SQL CI and SQL Release integrate with the CI 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.

The Suite comes with add-ons for TFS, Team City and Octopus Deploy, and open-source plugins are available for Bamboo and Jenkins.

If you use a different build server you can integrate via the SQL CI command line. And as SQL Release uses PowerShell cmdlets you can also work with any other release management tool or automation system.


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 SQL Developer Suite licensed?

The SQL Developer Suite is licensed per user. You can use the tools included in the Suite on any machine, so long as it's just you as a single user working with these tools. If several people are using the SQL Developer Suite, you'll need to purchase the appropriate number of user licenses.

How is the DLM Automation Suite licensed?

The DLM Automation Suite is intended for team use. A license for the Automation Suite enables you to install each tool once, on the appropriate 'agent' for that tool.

Typically, this means a build or release agent such as TeamCity's 'build agent' or Octopus Deploy's '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 install each of the tools once. 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 and Octopus Deploy tentacles on four 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?

For your personal use, all you need is the SQL Developer Suite under its per user licensing. This is the case even if you're using the SQL Compare command line on your desktop machine and, for example, a laptop.

If you're using the command line for a team use case – most commonly this involves automation using a continuous integration or release management system – you need to use the DLM Automation Suite. The SQL Developer Suite is licensed per user whereas the DLM Automation Suite is licensed per agent. In addition to the difference in licensing, the DLM Automation Suite offers additional tools that simplify and enhance the Database Lifecycle Management process. These tools include DLM Dashboard, SQL CI, and SQL Release.

How does the pricing of the SQL Developer and DLM Automation Suites compare?

The SQL Developer and DLM Automation Suites are both priced at $1,795 per bundle.

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

Getting your database under version control is the first step in successful Database Lifecycle Management. The tools in the DLM Automation Suite work best if each member of the team is also using Redgate's SQL Source Control, which is available as part of the SQL Developer Suite.

Worked example

One build agent, one release agent

Tom, a SQL Server developer at Company X, regularly 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 also 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) upon every check-in to SQL Source Control. SQL Release, which runs on a different machine, executes an automated deployment process using the NuGet package created by SQL CI.

Company X bought a 5-user SQL Developer Suite license for Tom and his team of four others, so they can take advantage of SQL Compare Pro for manual day-to-day compare and sync tasks, and SQL Source Control to get the database under version control. In addition, they purchased a single license for the DLM Automation Suite to run SQL CI on one TeamCity build agent and SQL Release on one Octopus Deploy tentacle (the release agent).

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 their SQL Server team. He encouraged his team of 10 to put their databases under version control to enable better collaboration and establish a single source of truth.

Now that the team has the databases under version control, they're using SQL CI on their build server to automatically test and integrate any changes once a day. SQL Release and Octopus Deploy, using one tentacle, run on a different machine to deploy changes to five target databases.

Dave bought a 10-user license for the SQL Developer Suite to cover SQL Source Control and a single license for the DLM Automation Suite, covering SQL CI running on one agent and SQL Release on another agent. 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. It just needs to be able to connect to the target database 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 then gets 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 Bundle 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