1: Creating repository based on existing dedicated SQL Pool

Instead of using this repository you can create your own database project based on a dedicated SQL Pool and just use the YAML code in the template folder instead.

You find out how to create your own database project for an existing dedicated SQL Pool in a blog post I wrote called Create a dacpac for an Azure Synapse Analytics dedicated SQL Pool using Azure Data Studio.

From there, you can look to synchronize the repository with a new repository in Azure DevOps. I covered this in detail in another blog post I wrote called Create a dacpac for an Azure Synapse Analytics dedicated SQL Pool using Azure DevOps.

You can then add the yaml file in the AzureDevOpsTemplates folder in this repository to your new one. From there you can select it when creating a new pipeline. I go into more detail about how to do this in a blog post called Connect a Database Project in Azure Repos to Azure Pipelines.

From there you can change the pipeline to deploy to your own environment.