How can we help you today? How can we help you today?

Deploy of environment specific data at release time using VSTS

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?
dsrofe
0

Comments

3 comments

Sort by
  • 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?
    Diogo
    0
  • dsrofe
    sql change automation
    dsrofe
    0
  • 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.
    Diogo
    0

Add comment

Please sign in to leave a comment.