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
- 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.
- 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.
- Review the commands that will undo the changes that were
made to the database catalog.
- 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.