Using a library control system to undo multiple changes

You can use your library control system to undo multiple changes that you have made to your database.

Procedure

To undo multiple changes, complete the following steps:

  1. Extract the Data Design Project that corresponds to your latest change. The library control system that you use determines how you can extract your Data Design Project. For example, if you use CVS, you can use the CVS Repositories view to extract your project.
  2. Open the change management script by expanding your Data Design Project in the Data Project Explorer and double-clicking the .changexml file.
  3. Undo your change by using the Undo button in the Messages section of the Change Management Script Editor.
    1. Click Undo. The Run Change Commands window opens.
    2. Review the commands that will undo the changes.
    3. Click Finish to undo the changes.
  4. Repeat steps 1 through 3 until you have undone all of the changes that you want to undo. You must undo your changes in the reverse of the order that you made the changes, and you must not skip any changes.

What to do next

After you undo your changes, your database catalog is returned to an earlier state.
Important: If data preservation was enabled, the data files were created when the change was deployed. These data files will be imported after the undo DDL is imported. If updates were made to the database after the change that you are trying to undo was made, be careful not to overwrite important changes. Depending on the situation, you might need to take additional action to ensure that the data that you are importing is current.

Feedback