Schema Change Tracking reports

Applies to: Dataedo 24.x (current) versions, Article available also for: 10.x, 23.x

Reports

There are 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:

Image title

  • Report header - allows you to change the scope of the report
  • Report body - displays content of the report - schema changes
  • Item details pane - this pane displays details of the selected element on 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 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 particular schema import when changes were detected and 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 user directly in the report
  5. Commented by - automatically saved username that last updated comment
  6. Commented date - automatically saved date and time when comment was last updated

Item details pane

Pane on the bottom of the report window shows details of change of object or element as list of its attributes and value before (Before column) change and after (After column) change.

Color coding:

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