StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      

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


DDT erasing TriggersExpand / Collapse
Author
Message
Posted 07/13/2007 9:33:44 AM


Advanced StrataFrame User

Advanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame User

Group: StrataFrame Users
Last Login: Today @ 7:38:08 PM
Posts: 617, Visits: 18,127
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?
Post #10255
Posted 07/13/2007 9:52:34 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Yesterday @ 10:49:29 PM
Posts: 4,379, Visits: 4,412
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.

Post #10263
Posted 07/13/2007 9:58:42 AM


Advanced StrataFrame User

Advanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame User

Group: StrataFrame Users
Last Login: Today @ 7:38:08 PM
Posts: 617, Visits: 18,127
thanks... luckily I had a good backup because the syntax on them was a real *****
Post #10265
Posted 07/13/2007 10:11:39 AM


Advanced StrataFrame User

Advanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame User

Group: StrataFrame Users
Last Login: Today @ 7:38:08 PM
Posts: 617, Visits: 18,127
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.
Post #10268
Posted 07/13/2007 10:24:32 AM


Advanced StrataFrame User

Advanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame User

Group: StrataFrame Users
Last Login: Today @ 7:38:08 PM
Posts: 617, Visits: 18,127
You can delete this entire thread.... there is no problem.

Sorry
Post #10269
Posted 07/13/2007 11:44:41 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Yesterday @ 10:49:29 PM
Posts: 4,379, Visits: 4,412
Good to hear....I wasn't able to reproduce when I tested it
Post #10274
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 7:48pm

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.047. 10 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.