Red Gate forums :: View topic - Feature Request: RollBack on script Failure
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Multi Script 1
SQL Multi Script 1 forum

Feature Request: RollBack on script Failure

Search in SQL Multi Script 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
vlitim



Joined: 24 Sep 2009
Posts: 1

PostPosted: Thu Sep 24, 2009 11:31 am    Post subject: Feature Request: RollBack on script Failure Reply with quote

At the moment seems that when an error occurs all you can do is stop executing. If this happens you are pretty much left in the lurch trying to pick through your scripts and start the process up again half way through a script, all the time the dbase you are tunning against is now half updated.

You really need to be able to execute all the scripts within one transaction so that any failure within any of the scripts rolls the dbase back to its previous state.

cheers
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group