Disabling DML triggers during data "Datalink" sync

aolcotaolcot Posts: 27 Bronze 2
We are using SQL source control v2.2.0.24 with mercurial and was wondering if it is possible to disable DML triggers from firing when getting the latest data changes.

I know that SQL data compare has the ability to disable DML triggers and it is an option that we use as part of our CI implementation. However, i can't seem to find anyway of configuring SQL source control to do something similar.

Any ideas or suggestions on how i may go about achieving this?

Many Thanks!

Comments

  • James BJames B Posts: 1,124 Silver 4
    Thank you for your post.

    The trigger-disabling options aren't set by default in Data Compare, which is why SQL Source Control doesn't set them either. Currently, there's no way I'm aware of to set the options that SQL Source Control uses so I don't know of a workaround for this.

    Do you feel the default would be better set to disable the triggers? Can you think of any scenarios where you *wouldn't* want this?
    Systems Software Engineer

    Redgate Software

  • aolcotaolcot Posts: 27 Bronze 2
    Hi Thanks for you reply.

    To be honest, I don't believe that the default should be to disable triggers. I have a scenario where triggers have been overused and totally misused by previous database developers and I am unable to reverse this development at this point in time. As such, for me, it isn't really the software doing something wrong, it is myself requiring the software to be more flexible because of bad design decisions made in the past.

    If anything, it would be absolutely great to see SQL source control provide the same options that would normally be provided natively through SQL Compare/Data Compare. The dropping/recreating of foreign keys with check/nocheck is another example "option" that should be configurable through SSC.

    I feel that having a little "Options" UI within SSC which then got passed through to compare/data compare during the sync process from source control would make the SSC solution hugely more flexible and configurable for us database developers that are haunted by past misdemeanours..

    I would appreciate your thoughts?
Sign In or Register to comment.