Extend DevOps processes to SQL Server databases with SQL Change Automation and Visual Studio

  • 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

SQL Change Automation comes in two editions

SQL Change Automation Core is available in Visual Studio Enterprise 2017.

See what’s included.

SQL Change Automation as part of Redgate’s SQL Toolbelt gives you more advanced, precise control over database deployments and more flexibility in how you want to manage database changes.

Find out more about SQL Change Automation.

FeaturesSQL Change Automation CoreSQL Change Automation
Write a migration script for a database change
Auto-generate migration scripts – powered by SQL Compare
Customize auto-generated migration scripts
Verify migration scripts locally
Deploy database migrations during a VS build
Organize migrations for easier branching/merging and navigation (Semantic versioning)
Pre/post deployment scripts
Extensions for build and release tools including VSTS, TFS, and Octopus Deploy
Work quickly and efficiently with code-based objects e.g. stored procedures (Programmable Objects feature)
Offline Schema Model for object-level history
Include static data alongside schema changes
Customize schema and data comparison options
Customize schema comparison filters
Generate a diff report of database changes
Generate a schema drift report
Generate a schema drift correction script
Easy deployment of CLR database objects
Support for state-based approach
Supported technologiesSQL Change Automation CoreSQL Change Automation
Visual Studio 2017 Enterprise edition
SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2005
Azure SQL Database
Visual Studio 2015 – all editions
Technical SupportSQL Change Automation CoreSQL Change Automation
Community support via forums, documentationFull Redgate support:
email, telephone, forums, documentation

How is SQL Change Automation different to SSDT Database Projects?

SSDT Database Projects takes a purely state-based approach to database deployment.

SQL Change Automation Core offers a migrations-first approach, which is focused on how to get to the desired end state through "migration scripts". This approach is ideal for more complex database changes as there is no ambiguity in how an upgrade will be performed.

Part of our Database DevOps solution

Redgate’s Database DevOps solution lets you extend your DevOps practices to SQL Server databases so that you can optimize productivity, agility, and performance across the full database lifecycle and become a truly high performing IT organization.

From safely making a change in development through to monitoring its impact in production, Redgate is with you every step of the way. We give you the tools and insight you need to optimize your development processes, so you can keep your team moving, keep adding value, and keep your data safe.

Learn more about the benefits