5: Only deploying updates for certain objects

There are a few different techniques you can use to only deploy updates for certain objects within a database project stored in Azure Repos.

I cover one technique in a post called Update both ends of Azure Synapse Link for SQL Server 2022 using Azure DevOps.

However, you can also exclude these objects in the 'Additional SqlPackage.exe Arguments' section of the (Azure SQL Database Deployment task)[https://github.com/microsoft/azure-pipelines-tasks/blob/master/Tasks/SqlAzureDacpacDeploymentV1/README.md] in Azure Pipelines.

Here is the link to view SqlPackage Publish parameters, properties, and SQLCMD variables.