Deploy Azure SQL External Tables Using an Azure DevOps CI/CD Pipeline
Quick answer: To deploy Azure SQL external tables through an Azure DevOps pipeline, replace hardcoded credential and data source values with SQLCMD variables, store the real values in Azure Key Vault, and pass them to SqlPackage using the /v: switch on the SqlAzureDacpacDeployment task. In an earlier post, we walked through setting up a full […]
A project which specifies SQL Server 2022 or Azure SQL Database Managed Instance as the target platform cannot be published to Microsoft Azure SQL Database v12.
While deploying a DACPAC project to Azure SQL Database using Azure DevOps, you may encounter an error due to specifying SQL Server 2022 as the target platform. The article provides steps to fix this issue by changing the target platform to ‘Microsoft Azure SQL Database’ in Visual Studio and rebuilding the project.