'How to deploy dacpac changes to SQL Server database hosted on azure vm

We have an Azure VM with SQL Server installed on it.

We have our Visual Studio SQL Server database project in an Azure git repository.

I've got the project to build using Azure Devops pipeline but I am not sure if it is :

  • Possible and
  • how to deploy to our SQL Server on the VM

I get the impression that VM deployment is deprecated and preferred method is using Azure SQL database but I can't be the only person to have inherited this setup-so if anybody can point me in the right direction it would be appreciated.

sql-serverazureazure-devopsvirtual-machinecicd


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions