How can we help you today? How can we help you today?

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

Hello,

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!

Regards:
Nemeth Balazs
Nemeth Balazs
0

Comments

2 comments

Sort by

Add comment

Please sign in to leave a comment.