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

arielman2304 676 Reputation points

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?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,583 questions
0 comments No comments
{count} votes

Accepted answer
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor

    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,

    0 comments No comments

0 additional answers

Sort by: Most helpful