StrataFrame Forum » StrataFrame Database Deployment Toolkit » Issues » DDT erasing Triggers

DDT erasing Triggers

Keith Chisarik — Fri, 13 Jul 2007 11:44:41 GMT

I know triggers aren't supported by the DDT yet, but here is my issue.

I have triggers in my SQL database, I just updated a table in the DDT to add some fields and deployed it to the server, it erased all my triggers.

How can I avoid this? I thought the rule was if the DDT doesn't need to update something it leaves it alone?

RE: DDT erasing Triggers

Trent L. Taylor — Fri, 13 Jul 2007 11:44:41 GMT

Good to hear....I wasn't able to reproduce when I tested it :)

RE: DDT erasing Triggers

Keith Chisarik — Fri, 13 Jul 2007 10:24:32 GMT

You can delete this entire thread.... there is no problem.

Sorry

RE: DDT erasing Triggers

Keith Chisarik — Fri, 13 Jul 2007 10:11:39 GMT

When I go to recreate them via CREATE TRIGGER scripts it says they already exist, though I cannot see them. They definitely exist because they are doing their job. The just disappeared from SQL management Studio when I ran the DDT deploy, they were definitely there 2 minutes before I did the deploy because I was reviewing their functionality with my boss.

I have rebooted and reloaded everything I could think of, any ideas?

Thanks.

RE: DDT erasing Triggers

Keith Chisarik — Fri, 13 Jul 2007 09:58:42 GMT

thanks... luckily I had a good backup because the syntax on them was a real *****

RE: DDT erasing Triggers

Trent L. Taylor — Fri, 13 Jul 2007 09:52:34 GMT

[quote]How can I avoid this? I thought the rule was if the DDT doesn't need to update something it leaves it alone? [/quote]

I am not sure why it is wiping them out. We will have to look at this. If the triggers are being stored off as sprocs or views then, yes, they will get removed. The DDT always removes and updates the sprocs and views. But we will look into it.