Schema Change Tracking reports

Reports

There are the following instances of Schema Change Tracking reports:

• Database schema object
  • Table
  • View
  • Procedure
  • Function
• Summary reports
  • Documentation
  • Module

All reports are available on the specified object form in the Schema Changes tab.

Report form

All Schema Change Tracking reports in Dataedo Editor have the same layout:

• Report header - allows you to change the scope of the report
• Report body - displays the content of the report - schema changes
• Item details pane - this pane displays details of the selected element in the report body

Reading and navigating the report

Levels - summary report

Documentation and module reports have the following levels:

1. Update time - this level represents a particular schema import when changes were detected
2. Operation type - type of operation that was performed on objects: Added/Updated/Deleted
3. Object - specific object that was added, updated, or deleted (table, view, function, or stored procedure)
4. Element - specific object element (column, key, parameter) that was added, updated, or deleted

Levels - object report

Tables, views, and other database objects have the following levels:

1. Update time and operation type - this level represents a particular schema import when changes were detected and the type of operation that was performed on the object: Added/Updated/Deleted
2. Element - specific object element (column, key, parameter) that was added, updated, or deleted

Report columns

1. Date / Operation / Object
2. Operation - type of the operation detected for this object
3. Type - type of object in this particular row
4. Comments - comments provided by the user directly in the report
5. Commented by - automatically saved username that last updated the comment
6. Commented date - automatically saved date and time when the comment was last updated

Item details pane

The pane at the bottom of the report window shows details of the change of an object or element as a list of its attributes and values before (Before column) and after (After column) the change.

Color coding:

1. Green - attribute was added
2. Red - attribute was deleted
3. Yellow - attribute was updated