What are the challenges you face when working across database platforms? Take the survey

Disable DML triggers while updating static data (Deploy database changes from a release artifact)


Azure DevOps - Redgate SQL Change Automation: Release task.

Currently stucked on a step, when static data updates on target server, a DML trigger fires, and change some data (ex. last change time) and then post schema validation failes, because of differencies.
In "SQL Data Compare" tool there are an existing option to "Disable DML triggers" in "Deployment behavior" but in SQL Source Control there is no existing options for that.
I can manually disable/enable all triggers on a database (via pre and post deployment script), but when both schema and data changes on same table this is not work, because trigger dropped and created (as enabled) before static data changes.
Any help could be approciated!

Nemeth Balazs

Best Answer

  • Options
    Sergio RSergio R Posts: 610 Rose Gold 5
    Hi Nemeth,

    You can use SQL Data Compare options in the Azure DevOps addon, have you already tried that?
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
Sign In or Register to comment.