Database schema change tracking

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

Schema Change Tracking keeps the 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).

Reports

Dataedo provides interactive schema change reports inside Dataedo editor.

There are three different reports:

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

Commenting

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.

Exporting

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