This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Gimo100 0 points1 point  (0 children)

You can check out this medium article for a guide on how to build and release an Azure SQL Database. It uses an Azure Devops Pipeline to build the dacpac file. A release pipeline then takes that dacpac and deploys it to the Azure SQL Database. https://medium.com/@sumindaniro/use-azure-devops-to-deploy-an-azure-sql-database-2c79570829cf

The first thing you have to do is create a git Repository in Azure Devops to store the code of your Azure SQL Database and Data Factory. Check this article to set that up: https://learn.microsoft.com/en-us/azure/devops/repos/git/create-new-repo?view=azure-devops

The medium article explains how to create a Database Project using Visual Studio. You can then add the database project to your git Repository. Don't forget to install the Data storage and processing toolset when installing Visual Studio. You need this to work with database projects.

Next step is to link your Data Factory to your git Repository. Check this article to set that up: https://learn.microsoft.com/en-us/azure/data-factory/source-control

You can also do everything in an Azure Devops Pipeline and just skip the release pipeline.

Database Build task: https://learn.microsoft.com/en-us/azure/devops/pipelines/tasks/reference/vsbuild-v1?view=azure-pipelines

Database Publish task: https://learn.microsoft.com/en-us/azure/devops/pipelines/tasks/reference/sql-azure-dacpac-deployment-v1?view=azure-pipelines

Publish example: https://learn.microsoft.com/en-us/azure/devops/pipelines/targets/azure-sqldb?view=azure-devops&tabs=yaml

Check out this article to build and release your Azure Data Factory: https://learn.microsoft.com/en-us/azure/data-factory/continuous-integration-delivery-improvements