Rollback changes when SQL Packager generated installer fails

Forum for users of SQL Packager database archive utility

Rollback changes when SQL Packager generated installer fails

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

Postby Michelle Taylor » Mon Oct 20, 2008 10: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: 537
Joined: Mon Oct 30, 2006 11:45 am
Location: Red Gate Software

Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests