Skip to main content

Database schema change tracking

Schema Change Tracking keeps the history of changes detected in source databases while importing schema using import schema changes functionality.

Schema change tracking overview

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).

Schema change tracking diagram

Reports

Dataedo provides interactive schema change reports inside the Dataedo editor.

Schema change tracking report

There are three different reports:

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

Commenting

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

Schema change tracking comments

Exporting

Dataedo 7 does not include schema change reports in the exports. They will be visible in Dataedo 8 through the Dataedo Web Portal feature.