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

Copper Contributor

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.

 

 

0 Replies