SQL Change Automation

What is SQL Change Automation?

Continuous integration and automated deployments for your SQL Server database

SQL Change Automation extends your application development processes so that you can also automate the delivery of your database. 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.

Automate your database change management process

SQL Change Automation completes the process of delivering your database by creating, testing, and deploying the database changes that you and your team verify in version control.

You get a fast and reliable way to verify and deploy database changes, and because SQL Change Automation connects to the build and deployment tools used for your application, you get more out of your existing infrastructure.

With database automation in place, you are free from manual database change management tasks, such as sorting deployment scripts, and can focus on value-added work.

Integrated review steps ensure that your versions are production-ready, the risk of database deployment issues is reduced, and you can start delivering updates to your customers as often as you want.

How SQL Change Automation Improves Your Database and Development Process

Detect bugs and accelerate database development with continuous integration

• Check the structure of your database, confirm that your changes can be deployed, and test your work with realistic data.
• Create tested packages that you can deploy with your CI or release management system, all in one process.
• Check how many statements in your database code are executed when you run your tests by using SQL Change Automation with SQL Cover.

Securely automate your deployments with built-in review steps

• Generate SQL scripts that securely automate database deployment, for use with your CI or version management system.
• Get a complete summary of SQL Server changes, including a summary and difference report.
• Provide your operations team with an optional review step before deploying changes to production.

Use as part of SQL Toolbelt to complete your database delivery process

• Trigger an automated build by verifying changes to version control with SQL Source Control in SQL Server Management Studio or through the SQL Change Automation Visual Studio extension.
• Set up automated testing as part of your CI process by creating tSQLt unit tests with SQL Test.
• Test your changes with realistic data, based on your column and table names, with SQL Data Generator.
• Get up-to-date documentation as part of your CI process with SQL Doc – ideal for compliance with SOX and other legislation.

System Requirements:

CPU: 1.8 GHz dual core processor

RAM: 2 GB

HDD/SSD: 50 GB of free space on main drive

Operating system: Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit, and Microsoft Windows Vista 32-bit

Resolution: 1024×768