Table of Contents:

    Database schema change tracking

    Piotr Kononow - Dataedo Team Piotr Kononow 2018-12-06

    This feature is available in Enterprise edition from version 7.2.

    Dataedo 7.2 introduced new metadata management functionality - Schema Change Tracking. It keeps history of changes detected in source databases while importing schema using import schema changes functionality.

    How it works

    During each schema import, if schema change tracking is enabled, Dataedo compares schema elements (tables, columns, data types and other attributes) and saves changes in the repository (in dedicated tables).


    Dataedo provides interactive schema change reports inside Dataedo editor.

    There are three different reports:

    1. Documentation level
    2. Module level
    3. Object level


    On the reports, users can comment specific schema changes using Comments field. Along with comment date and username who last updated comment is saved and displayed.


    Dataedo 7.2 does not include schema change reports in the exports but it is something scheduled for next release.

    Found issue with this article? Comment below
    Comments (0)