Azure DevOps
Published 31 July 2019
Installation
See Microsoft documentation for installation instructions
You can find the plugins on the Visual Studio Marketplace
Hosted Agents
SQL Change Automation supports Windows Hosted Agents
Local Agents
Requirements
- Powershell 3 or greater (download)
- Microsoft ODBC Driver 13.1 for SQL Server (download)
- Microsoft Command Line Utilities 14.0 for SQL Server (download)
After installing the above, the machine (or agent process) must be restarted: the above installer adds the utility to the PATH system environment variable, enabling SQL Change Automation to find and execute the SqlCmd utility.
Installation
You do not need to install anything, the add-on will automatically install and use the latest version of SQL Change Automation.
If this does not work for you, you can still follow the instructions in Installing and Updating PowerShell components
Examples
- Access Azure DevOps pipeline secret variable from SQL scripts
- Create a YAML pipeline to build, clone, inspect code, and deploy for a Pull Request workflow
- Use a service connection to store target database credentials
- Use the Azure DevOps Build extension with SQL Change Automation Project
- Use the Azure DevOps Build extension with SQL Source Control Project
- Use the Azure DevOps Release extension
- Use the Azure DevOps Release extension with an approval step
- Use the Azure DevOps Release extension with Windows Authentication credentials
