Rollback changes when SQL Packager generated installer fails

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

Rollback changes when SQL Packager generated installer fails

Postby golgotha1 » Sat Oct 18, 2008 8:56 pm

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?
golgotha1
 
Posts: 1
Joined: Sat Oct 18, 2008 8:14 pm

Postby Michelle Taylor » Mon Oct 20, 2008 11:11 am

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).
Michelle Taylor
 
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

cron