Red Gate forums :: View topic - Rollback changes when SQL Packager generated installer fails
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

Rollback changes when SQL Packager generated installer fails

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
golgotha1



Joined: 18 Oct 2008
Posts: 1

PostPosted: Sat Oct 18, 2008 8:56 pm    Post subject: Rollback changes when SQL Packager generated installer fails Reply with quote

Is there a way to force the database upgrade installer generated from SQL Packager to rollback any changes made by the installer to the target database prior to an error being generated?
Back to top
View user's profile Send private message
Michelle Taylor



Joined: 30 Oct 2006
Posts: 529
Location: Red Gate Software

PostPosted: Mon Oct 20, 2008 11:11 am    Post subject: Reply with quote

If you're using a SQL Packager-generated script (as opposed to packaging your own script), and haven't unselected the option to use transactions, it ought to roll back all the changes that can be rolled back. Changes that may still cause problems include user/login/security objects and full text cataloguing objects (because these objects can't always be created / altered within a transaction).
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