Database schema change tracking

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

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

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.

Found issue with this article? Comment below
Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
0
There are no comments. Click here to write the first comment.