Options

DML Trigger Folder

howarthcdhowarthcd Posts: 70 Bronze 3
edited October 22, 2009 5:25AM in SQL Compare Previous Versions
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
· Share on Twitter

Comments

  • Options
    Simon CSimon C Posts: 140
    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
    · Share on Twitter
Sign In or Register to comment.