Home

Welcome all!

This is the wiki dedicated to the repository that you can use as a template to perform CI/CD deployments for Azure Synapse Analytics serverless SQL Pools. Based on a blog post I wrote called CI/CD for serverless SQL pools using Azure DevOps.

This is a migration-based solution which works with Azure Synapse serverless SQL Pools. Based on the dbops PowerShell module.

You can also use this migration-based method for dedicated SQL Pools. However, you can also use the popular state-based method that you use for SQL Server with dedicated SQL Pools as well. Which is where you create a dacpac file.

I created a template that shows how to use the state-based method for dedicated SQL Pools in other repository called AzureDevOps-AzureSynapseSQLPool.

My intention is to build on this over time with any important information or significant links. For example, one thing I want to point out is that the quickest way to work with this repository in GitHub is to fork the repo.

In the meantime, feel free to checkout my blog posts relating to both Azure Synapse Analytics and Azure DevOps.

If you do find this repository useful please give it a star by clicking on the Star button in the top right-hand corner of this repository in GitHub.