Reputation: 6766
How do I exclude database triggers from a DACPAC project created in Visual Studio?
I have a database project in Visual Studio, and I need to exclude the database triggers from the generated DACPAC, because one of them is LockdownTriggers which prevents triggers from being altered - and that's causing issues with the other triggers; as soon as LockdownTriggers is deployed, it's automatically enabled. and then the rest of the deployment fails trying to alter other triggers that are now locked. Is there any way to prevent the database triggers from being deployed as part of the DACPAC? Or at least exclude LockdownTriggers, or prevent it from being enabled until the deployment is over?
Upvotes: 0
Views: 746
Answers (1)
Reputation: 6766
I found it! Searched around online some more and it looks like I need "Advanced Deployment Settings" (accessible via Project Properties > Debug > Advanced).
Upvotes: 0
Related Questions
- How to include created database project created dacpac into a cs project
- sqlpackage.exe to ignore a specific schema in DevOps Release pipeline
- How to not disable triggers during deployment in SQL Server
- How to disable predeployment and postdeployment scripts in DacServices.Deploy()
- Dacpac publish how to ignore create database statement?
- Deploying a via code dacpac without deploying database properties
- How do I stop Database deploy from removing Server Triggers?
- Parallel Dacpac deployment - Disable dependencies?
- Is there a way in a visual studio database project to exclude certain object during deployment?
- Exclude Certain Database Objects from the Build Depending on Configuration Settings