Azure synapse pipelines ,datasets,linked services connection how to move from DEV to UAT and PROD

Question

Hi,

i have pipelines pointing to dev resources like source as synapse database tables and destination CRM connectors (dev env.)

now we have to move from dev to uat & then production using GIThub ,when i moved to other environment what i need to do (minimal) changes so that in uat production pipelines and other resources remain entact?

currently have sources and destination as dev resources.

Answer 1

Hello Shreyash Choudhary,

Welcome to the MS Q&A platform.

While moving your pipelines from dev to UAT and PROD, you will need to parameterize connection strings, update the source and destination resources in the pipeline to point to the correct resources in the target environment, parameterize any pipeline parameters etc.

You can use the template parameter definition file to parametrize the values and on the release pipeline you can override the values on the override parameters section.

We have very good documentation on automating the CICD deployment using Azure DevOps.

Here you can choose Github as your source repository instead of the Azure DevOps.

Reference documents:

https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/how-to-use-ci-cd-integration-to-automate-the-deploy-of-a-synapse/ba-p/2248060

https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery

https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/source-control

https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery#use-the-synapse-workspace-deployment-task

I hope this helps. Please let me know if you have any specific questions.