Database schema change tracking

Piotr Kononow - Dataedo Team Piotr Kononow 6th December, 2018
Applies to: 7.x versions, Article available also for: 9.x (current), 8.x
You are looking at documentation for an older release.
Switch to the documentation for Dataedo 9.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
0
There are no comments. Click here to write the first comment.