Deploying Synapse serverless sql databases to another environment using Azure DevOps

Question

I am trying to create an Azure DevOps pipeline which would enable me to develop a serverless sql synapse database in my development environment (views, permissions etc.) and then deploy that database to test/prod environments. However, looking at the CI/CD documentation from Microsoft (see below) and from my own testing I get the impression that these won't actually copy the database but just the SQL scripts. In that case I would need to manually run all the SQL scripts to actually end up with the same sql serverless database with the same views and permissions etc. That is very error prone and does fit DevOps principles.

• https://techcommunity.microsoft.com/t5/data-architecture-blog/ci-cd-in-azure-synapse-analytics-part-4-the-release-pipeline/ba-p/2034434
• https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-deployment#overview

So my question is: can I develop a serverless sql database and then deploy it to another environment using Azure DevOps? Effectively what I am trying to do is what you would do with DACPACs except for Synapse serverless sql.

Thanks!

Answer 1

Hello @Edwin
,
Thanks for the ask and using the Microsoft Q&A platform .

At this time in serverless its not possible , but I am going to take this as feature ask to the product team . I will update you on this once I hear back from them .

Please do let me know how it goes .
Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

Answer 2

@HimanshuSinha-msft
Do we have any alternate ways to migrate the Synapse SQL Database between environments.

We are also Devops Synapse Workspace deployment to migrate the code.
However for synapse sql DB we need to manual create the Db in the each environment.

Please let us know is there any alternative way instead of manual efforrt