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
per agent

Buy now

How the DLM Automation Suite improves your SQL Server development process

Catch bugs and speed up database development with continuous integration

Speed up development, 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 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, automated database deployments with built-in review steps

Ship changes to your customers as soon as they’re ready, cut out human error at deployment, and help your operations team ensure changes are production-ready with built-in reviews, all from SQL Release.

  • Automate production deployments: generate and test SQL scripts that safely automate database deployments, for use in your favorite 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

Stop database drift with real-time schema monitoring

Check your databases are in their expected state before you deploy, and catch ad hoc changes that could cause deployment failure, with DLM Dashboard.

  • Get email alerts about unexpected changes: whenever your databases drift, you get an instant email alert from DLM Dashboard, with full details of the change and who made it.
  • 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.

Work with your existing CI server and release management tool

SQL CI and SQL Release plug into 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:

  • Use your favorite CI server: work with TFS, TeamCity, CruiseControl, Go, Jenkins, Hudson, Bamboo, or others. SQL CI also comes with plugins for TFS and TeamCity out of the box.
  • Deploy with any release management tool: SQL Release uses PowerShell cmdlets to deploy your database, so it integrates with Octopus Deploy, Release Management for Visual Studio, Bamboo, and more. SQL Release also comes with Octopus Deploy step templates out of the box.

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

The DLM Automation Suite tests and deploys your database 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.

Includes 10 tools and plugins for continuous integration, automated releases, and schema monitoring

SQL CI

Add your database to your continuous integration process

SQL CI TFS Build Plugin

Set up database CI with SQL CI, TFS, and SQL Source Control

SQL CI TeamCity Plugin

Set up database CI with SQL CI, TeamCity, and SQL Source Control

SQL Release

Make fast, reviewable production deployments of database changes

DLM Dashboard

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

SQL Compare command line

Compare and synchronize SQL Server database schemas from the command line

SQL Data Compare command line

Compare and synchronize SQL Server database contents 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

What our customers are saying

Works best with the SQL Developer Suite

The SQL Developer Suite includes SQL Source Control, a plugin that lets you use your source control system with your database. Database source 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 licensed per agent and intended for team use.

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?

You need one license per agent running Redgate automation tasks. If you have a single agent (e.g. TeamCity’s 'build agent' or Octopus Deploy’s 'tentacle') that handles Redgate automation tasks, you only need one license for this agent. If you have several agents, each running Redgate automation tasks, you need a license for each of these agents.

For example, if you are using SQL CI and SQL Release on the same agent, only one DLM Automation Suite license is required. If you are using SQL CI and SQL Release on two different agents, two licenses are required.

Both the SQL Developer 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 Suite are priced at $1,795 per unit – the former per user, the latter per agent.

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 with Redgate’s SQL Source Control, which is available as part of the SQL Developer Suite.

Worked example

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 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 2-agent license for the DLM Automation Suite to run SQL CI on a TeamCity build agent and SQL Release on an Octopus Deploy tentacle (the release agent).