StrataFrame Forum

DDT erasing Triggers

http://forum.strataframe.net/Topic10255.aspx

By Keith Chisarik - 7/13/2007

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?
By Trent L. Taylor - 7/13/2007

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

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.

By Keith Chisarik - 7/13/2007

thanks... luckily I had a good backup because the syntax on them was a real *****
By Keith Chisarik - 7/13/2007

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.
By Keith Chisarik - 7/13/2007

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



Sorry
By Trent L. Taylor - 7/13/2007

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