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?