Skip to content
| Marketplace
Sign in
Visual Studio>Tools>SQL Change Automation

SQL Change Automation

Redgate

|
5,022 clicks
| (2) | Free Trial
Extend DevOps processes to your SQL Server databases. Develop, source control, and safely automate database deployments alongside application changes.

This version of SQL Change Automation is for Visual Studio 2015.

Get the SQL Change Automation extension for Visual Studio 2022.

Get the SQL Change Automation extension for Visual Studio 2017 and 2019.

Redgate SQL Change Automation is a migrations-first database development and deployment tool inside Visual Studio, allowing you to extend DevOps processes to your SQL Server databases, so you can:

  • Prevent the database being a bottleneck to delivering value quickly
  • Automate the deployment of database changes with precision and control
  • Manage database changes alongside application changes for a single source of truth
  • Integrate with existing build and release tools including VSTS and TFS
  • Benefit from best of both migrations- and state-based approaches to database deployments

Incremental change

For each database change during development, a migration script is created. At release time these scripts form the building blocks for a full deployment script. By generating and deploying scripts in a predefined order, it saves both time and effort of having to do this release work manually.

Single source of truth

Changes are reviewed in development so any issues are spotted early, unpredictability is eliminated, and this all happens inside Visual Studio where database changes can be source controlled alongside application changes, establishing a single source of truth for both the application and the database.

Shift left

Its migrations-first approach, together with script verification, means developers can be confident that any database changes are developed early in the lifecycle, are tested and remain immutable from development all the way through to production.

Fit into your existing stack

SQL Change Automation works with existing release management tools such as Team Foundation Server (TFS), Visual Studio Team Services (VSTS), and Octopus Deploy for automated database deployments. This is ideal for developers looking for an easier, more accurate way to deploy their databases from Visual Studio.

The hybrid approach

SQL Change Automation is a ‘hybrid’ tool: it combines the best of both migrations- and state-based approaches to database development and deployment, so database changes are treated in the most sensible and efficient manner. Programmable objects such as stored procedures are handled more effectively, so they can be branched and merged without overwriting changes, and reference data can be source controlled alongside schema changes.

Precision

SQL Change Automation also lets you configure comparison settings and filters for precise results first time. In short, SQL Change Automation provides the most efficient and effective control over database deployments, which saves time and means users can deliver value quickly.

include_table_data.png

“This product is fantastic. Saves us a lot of time and makes our release process consistent and repeatable.” - John Adams, Database Developer, TrueBlue Inc.

For more information, visit the Redgate website or SQL Change Automation documentation.

Did you know Redgate has more extensions for Visual Studio to help you extend DevOps processes to SQL Server databases? Check out:

  • Redgate SQL Prompt Pro – improve productivity with advanced IntelliSense-style code completion to further ensure database development won’t be a bottleneck to delivering value quickly.
  • SQL Search – speed up database development by quickly searching for SQL objects and exploring across SQL Server databases.
  • Contact us
  • Jobs
  • Privacy
  • Terms of use
  • Trademarks
© 2023 Microsoft