Forum Discussion

aakashdesai's avatar
aakashdesai
Copper Contributor
Apr 01, 2022

Run Sql scripts using powershell in cicd pipeline on synapse sql dedicated pool

Hello Team,

 

We have synapse workspace (Dev and UAT). In Dev we have pre and post deployment sql scripts in Azure repo in .json format. I need to run this sql scripts (pre and post) deployment using powershell.

We have schemas, control tabel, Stored Procedure, External Table files in azure repo.
I need help for deploying this files in sequence using powershell in cicd pipeline on sql database.

 

 

No RepliesBe the first to reply

Resources