Automating database changes
Published 21 May 2018
SQL Change Automation allows you to automate the process of deploying changes to a database with confidence. It provides a set of PowerShell cmdlets that can validate the project and run tSQLt tests before deploying the changes to different environments.
It also provides a set of add-ons for continuous integration and continuous deployment servers, such as Team Foundation Server, Azure DevOps (formerly VSTS, Visual Studio Team Services), Octopus Deploy, TeamCity, Bamboo and Jenkins.
Broadly speaking there are two parts to the process of deploying changes. First the project is validated and a deployment package is produced. This process is termed the 'build'. This is explained in Continuous Integration.
The second part can be considered the 'release' step. This takes the deployment package produced by the build step and deploys it to the target environment. This is explained in Automated Deployments.
Unless otherwise stated all automation documentation supports both SQL Change Automation projects and SQL Source Control projects