Update pipeline parameters in the deployment to another environment through Azure DevOps

Question

Is there a possibility to change the components values listed with those of the target environment using Azure DevOps release pipeline?

• reference to SQL pool in the SQL pool stored procedure task
• integration runtime, URL and username in the Web task
• integration runtime in the linked services

Answer 1

Hi @Anonymous ,
Thanks for using Microsoft Q&A platform and posting your query.
Yes you can write a powershell script to replace any parameter like 'dedicated sql pool name' , 'spark pool name' , 'Integration Run time' Connection string and add a 'Run inline Powershell' task in your release pipeline to run the code .

Below is a set of sample code :

1. First code is to replace dedicated sql pool name .
2. Second one is to replace spark pool name.

   (Get-Content -path $(System.DefaultWorkingDirectory)/_SynapseRepo/annu-analytics/TemplateForWorkspace.json) -replace 'dev_sql_pool ','prod_sql_pool ' | Set-Content -Path $(System.DefaultWorkingDirectory)/_SynapseRepo/annu-analytics/TemplateForWorkspace.json   
   (Get-Content -path $(System.DefaultWorkingDirectory)/_SynapseRepo/annu-analytics/TemplateForWorkspace.json) -replace 'https://annu-analytics.dev.azuresynapse.net/livyApi/versions/2019-11-01-preview/sparkPools/devsparkpool','https://annu-analytics.prod.azuresynapse.net/livyApi/versions/2019-11-01-preview/sparkPools/prodsparkpool'| Set-Content -Path $(System.DefaultWorkingDirectory)/_SynapseRepo/annu-analytics/TemplateForWorkspace.json   
   

Here , you need to replace the path where '_SynapseRepo' should be replaced by the artifact name that you provided for release pipeline and 'annu-analytics' should be replaced with your synapse workspace name

Reference for artifact name:

Hope this will help. Please let us know if any further queries.

---

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Answer 2

The solution worked for me. thanks, AnnuKumari