1: Creating repository based on existing Azure SQL Database

Instead of using this repository you can create your own database project based on an existing Azure SQL Database and just use the YAML code in the template folder instead.

You can create your own database project for an existing Azure SQL database using a version of Visual Studio.

There are a fair few posts online on how to do this. I do provide some tips on how to do this using Azure Data Studio in a blog post I wrote called Tips about creating Database Projects in Azure Data Studio.

However, feel free to use a blog post I wrote called Create a dacpac for an Azure Synapse Analytics dedicated SQL Pool using Azure Data Studio as a reference point. Because it is same principle, you just do it for a connected Azure SQL Database instead.

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 workflow to deploy to your own environment.