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.

In short, the SPROCS and VIEWS already have this logic implemented.  When a SPROC or a VIEW is created through the DDT a database property is assigned to the code element in question that designates that the SPROC was deployed with the DDT.  The triggers, on the other hand at the moment, will be cleared out and re-deployed.  This is due to dependencies.  However, this has already been added to the list and will be in a near update.  My recommendation, however, would be to ensure that all of the trigger in which you need to support at the moment are part of your meta-data so that they are recreated as part of the deployment.