SQL Change 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 with confidence.
The solution for database deployment automation that helps accelerate software delivery and ensure quality code.
SQL Change Automation completes your database delivery process by building, testing, and deploying the database changes you and your team check into version control.
You get a fast, reliable way to check and deploy your database changes, and because SQL Change Automation plugs into the build and deployment tools you use for your application, you get more out of your existing infrastructure.
With database automation in place, you're 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.
Learn how teams can now use SQL Change Automation version 4 for collaborative database development across both Visual Studio and SQL Server Management Studio.
“True one-click deployment!”
“We can get value to customers sooner, with quality feedback loops and faster releases of features.”
Contact us to find out how Redgate Flyway can help your team deliver value quicker while keeping your data safe.
Redgate has specialized in database software for 25 years. Our products are used by 804,000 IT professionals, in more than 100,000 companies.
Redgate offers comprehensive documentation and a friendly, helpful support team. An average 87% of customers rate our support 'Excellent'.
Redgate also provides add-ons and extensions for:
TeamCity | |
Azure DevOps Server (formerly TFS) | |
Azure DevOps Services (formerly VSTS) | |
Octopus Deploy | |
SQL Server Management Studio (SSMS) |
SQL Change 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), SQL Change Automation runs them for you as part of your CI process.
SQL Change 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 SQL Change Automation have full support for data changes, and you can include static data.
SQL Change 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.
When you're ready to deploy, SQL Change 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.
SQL Change Automation lets you choose between a state-based approach for simple changes, and a migrations-based approach for complex changes. Find out more.
SQL Change 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.
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