Rolling back changes from a deployed change plan

After the changes in a change plan are run and applied to the database catalog, you might decide that the changes need to be backed out. Running an undo script rolls back the changes.

Before you begin

You can roll back the changes only when the status of the change plan is DEPLOYED. In addition, an undo script must have been generated for the change plan. Unless you change the default behavior, an undo script is generated when a change plan is deployed. A connection to the database where you want to rollback the changes must exist.

About this task

For an undo script to run correctly, all of the commands that were deployed in the change plan must have run successfully. When you run a change plan, you should check the SQL Results view to determine if any commands fail and take corrective action.

Procedure

  1. In the Administration Explorer, find the database and expand its contents. Click the Change Plans folder. The change plans for the database are displayed in the Object List.
  2. Right-click the change plan that you want to reverse the changes for, and click Review Undo Commands. You can click View instead to see the changes that were in the change plan before you review the undo script. The Review and Deploy dialog for undoing commands opens.
  3. Review the commands that will undo the changes that were made to the database catalog.
  4. Click Run and then click Finish to apply the undo commands to the database catalog.

Results

The changes that you made to your database have now been reversed. The results of running the commands are displayed in the SQL Results view.

Feedback