Database schema change tracking reports

Applies to: 8.x versions, Article available also for: 9.x (current), 7.x
You are looking at documentation for an older release.
Switch to the documentation for Dataedo 9.x (current).

This feature is available in Enterprise edition

This article describes Schema Change Tracking reports available in Dataedo Editor Enterprise.

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:

  • Report header - holds parameters and options of the report and button to generate 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

Running the report

  1. Select report time scope from the list
  2. Click Generate button

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
Found issue with this article? Comment below
0
There are no comments. Click here to write the first comment.