How to do Deployment process of Dedicated synapse SQL Pool

Gandhi, Rajiv (Contractor) [IT/US/DEN] 11

i want to know How to do Deployment process of Dedicated synapse SQL Pool in Azure Dev ops

AnuragSingh-MSFT 21,551 Reputation points Moderator

2022-11-22T06:36:42.533+00:00

@Gandhi, Rajiv (Contractor) [IT/US/DEN] , thank you for posting this question here.
Please see the following link which contains tutorial outlining how to integrate your SQL Server Data tools (SSDT) database project with Azure DevOps and leverage Azure Pipelines to set up continuous integration and deployment - Continuous integration and deployment for dedicated SQL pool in Azure Synapse Analytics

For specific DevOps related questions, you may also utilize the forums below related to Azure DevOps as it is currently not supported in the Q&A forums.

Developer Community, or through
Azure Devops Support.

Hope this helps. Please let me know if you have any questions.
AnuragSingh-MSFT 21,551 Reputation points Moderator

2022-11-24T11:39:27.633+00:00

@Gandhi, Rajiv (Contractor) [IT/US/DEN] , Following up to check if the responses below helped. Please let us know if you have any questions.

---
Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.

1 answer

Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator

2022-11-22T08:26:34.033+00:00

Below blogs can help:
wherein you can use Release pipelines for deployment
https://datasharkx.wordpress.com/2021/03/11/automated-deployment-of-azure-sql-database-azure-sql-data-warehouse-through-azure-devops-via-service-principal-part-1/
https://datasharkx.wordpress.com/2021/03/12/automated-deployment-of-azure-sql-database-azure-sql-data-warehouse-through-azure-devops-via-service-principal-part-2/
Please sign in to rate this answer.

2 people found this answer helpful.
Gandhi, Rajiv (Contractor) [IT/US/DEN] 11 Reputation points

2022-11-24T11:52:05.087+00:00

Please share some different approach.

Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator

2022-11-24T15:19:53.403+00:00

Can you be more specific what you are expecting? What are your scenarios?
There can be another way wherein you set up your own agent and use command line to deploy the dacpac. But it is more maintenance aspect for the devols team

Gandhi, Rajiv (Contractor) [IT/US/DEN] 11 Reputation points

2022-11-24T15:34:02.14+00:00

Actually we already started ADF deploy process through azure Dev ops.
Now we required to do same for data base. Actually we have servers in Azure synapse analytics as Azure Dedicated SQL pool. We tried some documents to do deployment process for deticated pool but no luck.
So if you share some step by step process documents to achieve would be a valuable support

ShaikMaheer-MSFT 38,551 Reputation points Microsoft Employee Moderator

2022-12-02T06:49:39.093+00:00

Hi @Gandhi, Rajiv (Contractor) [IT/US/DEN] - Above shared links explains same right? Are you facing any issue or errors with it? Also, little unclear here when you say ADF deploy process started. ADF and Synapse are two different services. So, we can have their deployments separately.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer