Deployment of Synapse Serverless SQL pools through Azure Devops (CI/CD)

Tej 146 Reputation points

We have a requirement of deploying the stored procedures to UAT and Test that is being created in the serverless synapse SQL environment

Could someone please assist in providing the step by step process or document on how to perform CICD process of serverless synapse SQL objects through Azure Devops?

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.
3,527 questions
{count} votes

Accepted answer
  1. BhargavaGunnam-MSFT 19,236 Reputation points Microsoft Employee

    Hello @Tej ,

    Welcome to the MS Q&A platform.
    Please correct me if my understanding is wrong. You want to know how to deploy SQL objects(SPs) to an existing Serverless SQL pools in UAT and test environments through Azure DevOps.

    If this is your requirement, the below thread explains the deployment of SQL scripts on Serverless SQL pools.

    Or if you want to deploy/migrate the following SQL Objects- Database(serverless SQL pools), Database Master Key Encryption, Database Scoped Credential, Schema, External Data Sources, External File Formats, External Tables, Views, and Stored Procedures, please follow the below thread. The Release Pipeline contains the Azure Synapse Workspace Deployment task which is followed by a PowerShell task responsible to deploy the Serverless SQL Pools. The PowerShell script is attached to the answer.

    Please let us know if you have any further questions.

2 additional answers

Sort by: Most helpful
  1. Kevin Chant 5 Reputation points

    I will leave this here in case anybody is still looking to do this using Azure DevOps.

    1 person found this answer helpful.

  2. 2022-11-21T07:23:42.197+00:00

    @ BhargavaGunnam-MSFT,

    Please post steps for Deployment process of Dedicated SQL Pool

    0 comments No comments