Azure SQL Database
An Azure relational database service.
6,326 questions
Execute sql script on dedicated pool using cicd pipeline.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 75%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Aakash Desai
16
Reputation points
Hello Team,
We have sql scripts in azure repo, pushed from synapse workspace. But in synapse, sql script are .sql format and after they are pushed to azure repo they are in .json format.
How do i run these sql script on dedicated pool using cicd pipeline.
Thank you
Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,373 questions
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator2022-03-23T22:03:17.28+00:00 Hello @Aakash Desai ,
Thanks for the question and using MS Q&A platform.
As I understand the ask here is that you would want to know how to run the SQL scripts saved as .json format in Azure repo on Azure synapse dedicated pool using Azure pipeline (CICD). Please correct me if I'm wrong.
Is this something you are looking for? - how to execute sql script using azure devops pipeline
If this is not helpful, could you please help provide more details about the requirement?
And if your requirement is more implementation from Azure Pipelines/DevOps then I would recommend reaching out in Azure DevOps community forum as that forum is more specific to Azure DevOps related queries and we have our Azure DevOps experts who would be happy to assist.
In case if your requirement is more of implementation from Azure Synapse studio standpoint, then please provide more details so that we can better assist you.
Thank you
-
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator
2022-03-24T22:59:05.81+00:00 Hello @Aakash Desai , Just checking to see if you have got a chance to see my previous comment if so, could you please respond confirm the details motioned?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 57.00000000000001%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
AAKASH DESAI 1 Reputation point2022-03-29T04:58:40.837+00:00 Hello,
We have DAcpac files, which we want to run using cicd pipeline on sql dedicated pool.
COuld you please help me with steps to configure pipeline using dacpac file and execute it. Also what dependencies will it require to run like modules, firewall opening etc.
NOte: We are using self hosted agent not microsoft hosted agent to run pipeline. -
AAKASH DESAI 1 Reputation point
2022-04-01T12:52:18.26+00:00 Hello Team,
I need to run sql scripts using powershell in cicd pipeline in a sequence.
Could you please help me with steps how can i proceed further.Thank You.
Aakash -
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator
2022-04-07T21:17:07.287+00:00 Hello there,
The scope of the ask is not very clear as it has been changed from the initial post (sql script -> DAC pac --> now powershell). Could you please clarify what is your requirement and what azure services are being used to achieve it?
In case if your requirement is to execute SQL scripts using azure DevOps pipeline, then please refer to this thread where a similar topic has been discussed - how to execute sql script using azure devops pipeline
Sign in to comment
Sign in to answer