What are the challenges you face when working across database platforms? Take the survey
Options

Feature Request: RollBack on script Failure

vlitimvlitim Posts: 2
edited September 24, 2009 6:31AM in SQL Multi Script
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
Sign In or Register to comment.