You can undo the changes that you make with a change management
script.
Before you begin
You cannot undo changes that you made with a change management
script that you manually edited.
About this task
Use the Change Management Script Editor to
run a script that reverses the changes that you made to your database
by running a change script.
Procedure
To undo your changes, complete the following steps:
- If your change management script is not already open in
the Change Management Script Editor, complete
the following steps to open it:
- In the Administration Explorer,
drill down to the database that you want to reverse changes and expand
its contents. Expand the Change Management Scripts folder.
- Double-click the change management script that you want
to open. Change management scripts have file names that
end with .changexml.
- Optional: Expand the Commands section
of the Change Management Script Editor, and click Edit
Undo to preview the undo commands in the SQL
and XQuery Editor. Close the SQL and XQuery Editor when
you are through verifying the undo commands.
- Expand the Messages section.
- Click Undo to start the Run
Undo Change Commands wizard.
- On the Change Commands page of the wizard, review
the commands that the Change Management Script Editor will run.
- Click Finish to apply the changes
to your database.
Results
The changes that you made to your database have now been reversed.