Hi all, Jim here.



Currently i having an issue while upgrading the existing database by DDT. Existing database containing trigger that not created by DDT. Now after i install DDT supposed to only modify the structure of database by without removing the existing trigger.

I had checked the DDT, inside do not contains any new trigger/ any history on deleting the trigger. Do i have miss out any setting i can do?



Does anyone can provide some guideline on the this issue?



Thanks a lot.

Hi Jim,



Where have your database triggers come from if they were not part of the original DDT package? You can create triggers within the DDT and I would assume they would have been imported via the Import Database Structures option (haven't imported triggers myself but I assume it would work).



However, if your triggers are being added by SQL Server (maybe for replication) after you have deployed the database then you may have a problem as there is currently no way to tell DDT to leave these triggers in place. Check this post for more information:-



http://forum.strataframe.net/Topic22646-12-1.aspx



Aaron