0

So I figured out how to disable the triggers from being part of a DACPAC, but unfortunately that's just a user level setting in Visual Studio, so I can't save it to source control and deploy the solution with those changes.

There's got to be some way to filter out the triggers from the DACPAC in the definition of the deployment pipeline task. But I have no idea where to start; all I see are some text fields and none of them are even generic "command line options" fields...

ekolis
  • 6,270
  • 12
  • 50
  • 101
  • You could try to add the [argument](https://learn.microsoft.com/en-us/sql/tools/sqlpackage?view=sql-server-2017#properties-specific-to-the-publish-action) /p:DisableAndReenableDdlTriggers=True, It specifies whether Data Definition Language (DDL) triggers are disabled at the beginning of the publish process and re-enabled at the end of the publish action. – Vito Liu Nov 23 '20 at 08:57
  • How do I specify that in the context of an Azure DevOps release pipeline task? I'm looking at the task definition and there's no field for command line arguments... – ekolis Dec 03 '20 at 20:51
  • Oh, I had some sort of composite "task group" thing, I had to dig into the actual task to add that option. Still, it didn't work; I get the same errors... – ekolis Dec 03 '20 at 21:27

0 Answers0