Clarification on the "Ignore Triggers" option in the SQL Compare command-line version

Category: Troubleshooting & error messages
Date: 16 Jul 2009
Product: SQL Compare
Versions: SQL Compare (command-line) 5 - 8

When using /exclude:Trigger to exclude DML triggers during synchronization, the DML triggers are not ignored.

The current version of SQL Compare does not consider Data Manipulation Language triggers as objects in their own right, but rather attributes of a table. Therefore, trying to exclude triggers in the same way as excluding a table, view, or stored procedure will not have the desired effect. Luckily, SQL Compare has an option that especially ignores DML triggers.

Using /o:it instead of /exclude:Trigger will allow triggers to be ignored during synchronization.

The object type 'Trigger' (mentioned in the help for sqlcompare.exe that can be viewed by typing 'sqlcompare /? /verbose | more' in a command prompt) specifically refers to Data Definition Language (DDL) triggers. Therefore, using the option /exclude:Trigger will omit only DDL triggers from the schema comparison.

For further information on the various command line switches and options, please refer to the following:
http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Compare&c=SQL_Compare/help/8.0/sc_cl_Switches_in_the_cl.htm&toc=SQL_Compare/help/8.0/toc547562.htm

Document ID: KB200709000153 Keywords: SQL,Compare, ignore, exclude, trigger,DDL,DML,API

Was this article helpful?

Search support