How to execute SQL script via Azure Pipeline, please help, I don't want to do it via powershell. Please suggest.

Question

How to execute SQL script via Azure Pipeline, please help, I don't want to do it via powershell. Please suggest.

Answer 1

Hi

Thanks for reaching out to Microsoft Q&A.

I think you are trying to execute sql script via azure data factory? let me know if its not that you are asking for.

See the below link which demonstrates how to run a sql script using script activity in azure data factory or synapse pipelines.

https://techcommunity.microsoft.com/t5/azure-data-factory-blog/execute-sql-statements-using-the-new-script-activity-in-azure/ba-p/3239969

Let me know if this helped.

Please Upvote and Accept as answer if the reply was helpful, this will be helpful to other community members.

Answer 2

Hi Amit Srivastava •,

Thanks for posting this question.

As I understand, you want to execute SQL script via Azure Pipeline of ADO.

Please let us know if you have different ask.

We request you to raise request in Azure DevOps Forum as we do not support Azure DevOps on this forum currently.

Thank you.

Answer 3

Hey, Assuming this you are asking about Azure devops pipeline , there is a sql script task within AUre devops pipeline else if Azure data factory, you can follow Vinodh's suggestion above