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

DML Trigger Folder

Is it possible, when scripting a database using SQL Compare, to specify that DML triggers be created on a one-script-file-per-object basis?

Currently trigger definitions are appended to the table script file containing the relevant CREATE TABLE statement, which can be a pain if you have triggers that are frequentlly modified. My current workaround is to manually cut and paste the CREATE TRIGGER statements into new files.

Thanks
Chris
howarthcd
0

Comments

1 comment

Sort by
  • Simon C
    Unfortunately, this isn't currently possible with the current version of SQL Compare. DML triggers and indexes are treated as part of a table, and changing this would require a large rewrite of the core of the SQL Compare engine. It is something that's been requested quite a few times before, so it is something we might consider in a future version.

    Simon C
    Simon C
    0

Add comment

Please sign in to leave a comment.