Using the Change Management Script Editor to undo changes to a database

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:

  1. If your change management script is not already open in the Change Management Script Editor, complete the following steps to open it:
    1. 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.
    2. Double-click the change management script that you want to open. Change management scripts have file names that end with .changexml.
  2. 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.
  3. Expand the Messages section.
  4. Click Undo to start the Run Undo Change Commands wizard.
  5. On the Change Commands page of the wizard, review the commands that the Change Management Script Editor will run.
  6. Click Finish to apply the changes to your database.

Results

The changes that you made to your database have now been reversed.

Feedback