You can use your Data Design Projects to audit the changes
that have been made to your databases.
Procedure
To extract your projects and to review the changes that
have been made, complete the following steps:
- Extract the Data Design Project that corresponds to the
specific change that you want to audit. 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.
- Review the change management script to audit the following
aspects of the change:
- Objects that the change impacted
- Commands that made the change
- Messages that resulted from executing the commands
- Undo commands that can reverse the change