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.
“True one-click deployment!”
“We can get value to customers sooner, with quality feedback loops and faster releases of features.”
“It's now a minor overhead to deploy.”
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.
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.
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.
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.
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.
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.
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.
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
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