Is there option to build dacpac only when there are changes?

Question

Hi,
I'm using Visual Studio 2019 to build sql project.

The issue is that building and deploying the dacpac to our database takes up most of our deployment time, when A lot of times, there are no changes to the database.

Is it possible to not have the dacpac build when there are no changes to the database?

Answer 1

Hi arielman2304-0180,

I’m afraid there is no option to build DACPAC only when there are changes currently. Here is a feedback.
I recommend you vote for this feedback or submit a new feedback to this link.
Your feedback is valuable for Microsoft to improve the level of products and service. If the requirement mentioned by customers for many times, the product team may consider adding this feature in the next version. Appreciate for your understanding.

Best Regards,
Amelia