Extracting Data Design Projects to audit changes

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:

  1. 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.
  2. Open the change management script by expanding your Data Design Project in the Data Project Explorer and double-clicking the .changexml file.
  3. 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

Feedback