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 GitHub. I covered this in detail in another blog post I wrote called Create a dacpac for an Azure Synapse Analytics dedicated SQL Pool using GitHub Actions.

You can then add the yaml file in the .github/workflows folder in this repository to your new one. Which will automatically add a new workflow.

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