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

arielman2304 676 Reputation points
2021-06-23T07:05:17.603+00:00

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?

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

Accepted answer
  1. AmeliaGu-MSFT 13,991 Reputation points Microsoft Vendor
    2021-06-23T09:06:02.713+00:00

    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

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.