StrataFrame Forum » StrataFrame Database Deployment Toolkit » Enhancement Requests » Triggers Instead of for Views

Triggers Instead of for Views

Michel Levy — Tue, 14 Sep 2010 11:24:00 GMT

when importing SQL database, I can't see the triggers instead of, actually existing on the views.
And on a new view I design in DDT, I can't write Trigger instead of.

Would it be possible to add these functionalities in a next version, please?

RE: Triggers Instead of for Views

Michel Levy — Tue, 14 Sep 2010 11:24:00 GMT

Ah :P
thank you Dustin!

I know I can use pre and post-deployment scripts to drop/create it, but it is still not visible in DDT.

RE: Triggers Instead of for Views

Dustin Taylor — Tue, 14 Sep 2010 09:42:01 GMT

Added it to the list :). We're actually wanting to re-vamp the DDT pretty extensively and add quite a few new bells and whistles. I've added this one specifically to make sure it doesn't get overlooked.

In the mean time, you can manage your triggers for the view using Pre and Post deployment scripts. A pre-deployment script can drop the trigger, and a post-deployment can re-deploy it, which should get you want you are looking for.