This guide will walk you through setting up the different components of a SQL Change Automaton pipeline.

Setting up SQL Change Automation on a development environment

1. Select a database on a SQL Server instance to be your development database
2. Pick a client machine on which to install SQL Change Automation
3. Ensure SQL Server Management Studio and Visual Studio are installed on the client machine
4. Install a version control system on the client machine
5. Ensure the client machine can connect to the SQL Server instance with the correct permissions
6. Download and install the SQL Toolbelt installer on the client machine
   
   • See Installing Visual Studio Extension

See Getting started with SQL Change Automation projects in Visual Studio for more information.

Setting up SQL Change Automation for Continuous Integration and automated deployments

The processes for conducting Continuous Integration and automated deployments are similar.

1. Install build and release agents and configure them with administrator access
   • TeamCity is recommended for builds
   • Octopus Deploy is recommended for releases
2. Identify a SQL Server instance to be used by the build agent for validation purposes
   • Ensure the build agent machine has access to this SQL Server instance
3. Ensure the agent machines have PowerShell 3.0 (or higher) installed
4. Identify an accessible NuGet feed to use
   • Some Continuous Integeration tools will provide a NuGet feed for you
5. Download and install the SQL Toolbelt installer on the agent machines
   
   • See Installing Powershell components
6. If possible, install the SQL Change Automation add-on for your chosen Continuous Integration and automated deployment tools
   • See Add-ons

See Getting started with the SQL Change Automation PowerShell components for more information.