Can I exclude db schema objects from dacpac using custom configuration in visual studio.

Bhagyashree Singh Deo 0 Reputation points
2023-05-30T19:48:51.6366667+00:00

What is the excluding logic to exclude all db schema objects and include only 1 table or stored procedure which is updated in visual studio. Currently we have 1 dacpac for our Database due to this when any new projects are developed,the sql components are deployed much before the actual release of the project. We don't want to deploy all the db objects, only one where code change that needs to deploy. How to publish dacpac project excluding the db objects.

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

1 answer

Sort by: Most helpful
  1. Chandu_0124 11 Reputation points
    2023-06-01T03:10:16.0833333+00:00

    @Bhagyashree Singh Deo

    Did you try to check DROP objects in target but not in project option?, before you go in Advanced you should be able to get it enabled.

    [enter image description here

    ](https://i.stack.imgur.com/WT8J4.png)

    0 comments No comments