Packages and compresses schema and contents of SQL Server databases
Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne
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?
- Posts: 1
- Joined: Sat Oct 18, 2008 8:14 pm
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).
- Posts: 529
- Joined: Mon Oct 30, 2006 12:45 pm
- Location: Red Gate Software
Return to SQL Packager 6
Who is online
Users browsing this forum: No registered users and 0 guests