How to deploy only required SSDT project when we have multiple projects in Visual Studio Project solution? (Azure SQL Database objects deployment)

Tej 146 Reputation points

Hi team,

I want to deploy multiple Azure SQL database objects through dacpac deployment task. The challenge is I have multiple SSDT projects in visual studio project solution, but I want to deploy one SSDT project as per requirement through CICD pipeline in Azure devops. Is there any option to only deploy the required objects and ignore rest?

Could someone please suggest how to create a dacpac file against the required SSDT project and deploy it.

@BhargavaGunnam-MSFT , @ShaikMaheer-MSFT

Could you please assist on this?

Azure SQL Database
{count} votes

1 additional answer

Sort by: Most helpful
  1. Tej 146 Reputation points

    Also, I have another query, if I include my database objects inside the existing database project in some different folder, How to deploy it through the dacpac file if want to include only the objects inside the folder?

    It would really helpful if you can clear my queries.

    0 comments No comments