Database schema change tracking

Applies to: Dataedo 23.x (current) versions, Article available also for: 10.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.

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.