| Author |
Message |
golgotha1
Joined: 18 Oct 2008
Posts: 1
|
 Posted: Sat Oct 18, 2008 8:56 pm Post subject: Rollback changes when SQL Packager generated installer fails |
 |
|
| 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 |
|
 |
Michelle Taylor
Joined: 30 Oct 2006
Posts: 519
Location: Red Gate Software
|
| Posted: Mon Oct 20, 2008 11:11 am Post subject: |
|
|
| 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 |
|
|
|
|
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
