Deploy of environment specific data at release time using VSTS

dsrofe

We use VSTS and have an automated CI/CD pipeline that uses a single build that can get deployed to QA, UAT, Production, etc.  Reference data to be deployed is specific to the environment so the data to be deployed cannot be determined at build time but rather at release time.  Is there a way to do that using SQL Change Automation: Release or possibly PowerShell?

Diogo

Hi @dsrofe,

This would depend on what kind of project you have. Are you using a SQL Source Control project or a SQL Change Automation project?

dsrofe

sql change automation

Diogo

At present there is no way to do this using the SQL Change Automation VSTS plugin. It should be possible with SQLCMD variables, however these are not yet supported in SQL Change Automation. This is a high priority for us, so you should hear something in the near future.