Documentation

Table of Contents:


    Database schema change tracking reports

    Piotr Kononow - Dataedo Team Piotr Kononow 2018-12-10

    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
    Comments (0)