SQL Change Automation Core is available in Visual Studio Enterprise 2017.
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.
Features | SQL Change Automation Core | SQL 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 technologies | SQL Change Automation Core | SQL 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 Support | SQL Change Automation Core | SQL Change Automation |
Community support via forums, documentation | Full Redgate support: email, telephone, forums, documentation |
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.
Redgate helps IT teams balance the need to deliver software faster with the need to protect and preserve business critical data.
Your business benefits from a DevOps approach to database development, while staying compliant and minimizing risk.
Learn more about the benefits