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:
- 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.
- Open the change management script by expanding your Data
Design Project in the Data Project Explorer and
double-clicking the .changexml file.
- Undo your
change by using the Undo button in the Messages section
of the Change Management Script Editor.
- Click Undo. The Run
Change Commands window opens.
- Review the commands that will undo the changes.
- Click Finish to undo the changes.
- 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.