Continuous integration and automated deployments for your SQL Server database

DLM Automation extends your application development processes so you can automate your database delivery too. You get instant feedback on your code changes, get the exact script you need for release automation and, when you’re ready, you can deploy to production in confidence.

Automate your database change management process

A capability of the SQL Toolbelt, DLM Automation completes your database delivery process by building, testing and deploying the database changes you and your team check into version control with SQL Source Control.

You get a fast, reliable way to check and deploy your database changes, and because DLM Automation plugs into the build and deployment tools you use for your application, you get more out of your existing development infrastructure.

With database automation in place, developers are freed up from manual database change management tasks, like sorting out deployment scripts, and can focus on more value-added work instead.

Built in review steps ensure that your releases are production ready, the risk of database deployment problems is reduced and you can start delivering updates to your customers as frequently as you like.

Join our next DLM demo webinar

Discover how SQL Source Control and DLM Automation work with build and release management tools to automate database changes, and get the chance to ask our experts questions.

Join the next DLM Demo webinar or watch previous ones

How DLM Automation improves your database and development process

Catch bugs and speed up database development with continuous integration

  • 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 CI 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

  • 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.
  • Provide your operations team with an optional review step before deploying changes to production.

Extend the systems you use to build and deploy your applications

  • Make more of your existing build and release management tools with DLM Automation plug-ins or PowerShell integration
  • Choose from one of the free add-ons available for TeamCity, Team Foundation Server, Visual Studio Team Services and Octopus Deploy
  • Use DLM Automation PowerShell cmdlets to integrate with any build or deployment tool or create your own customized workflow

Use as part of the SQL Toolbelt to complete your database delivery 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

DLM Automation works with

Or any build or release tool that can run PowerShell

Key features

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 your CI process.

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.

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 or column name changes.

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. It also runs a final validation check to make sure your changes were successful.

Get the exact script your 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 later review, or add it to your release management tool.

Review and approve database changes in your release tool

DLM Automation includes a review step that integrates with your deployment tool. You can check the script, get a full report on the differences, and see warnings if there's any chances of data loss.

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

DLM Automation uses the world's most trusted technology for SQL Server database changes: SQL Compare. It's the industry standard for synching and deploying SQL Server databases, used by 30,000 organizations. You can count on efficient deployments with zero errors.

DLM Automation is a capability of the SQL Toolbelt

SQL Toolbelt contains the industry-standard products for SQL Server development, deployment, backup, and monitoring, including SQL Source Control and DLM Automation. Together, they make you productive, your team agile, and your data safe.

Download the SQL Toolbelt

Discover the benefits DLM can bring to your team

Database Lifecycle Management (DLM) gives you a trusted, scalable and repeatable database change management process. You can deploy more frequently in confidence, adding more value to your business and your customers.

Learn more about the benefits

Get in touch, we'd love to help

Whether you need advice taking your first steps into DLM, you have a question on how you can improve your current setup, or maybe you have questions about our tools and purchasing options.

Katherine is part of the DLM Automation team