Updating descriptions from database

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

Dataedo repository is a master data source for all descriptions. This means that once you entered a description with Dataedo editor or imported with schema they are never overwritten with subsequent schema updates, even if descriptions changed in the database. Those changes are ignored.

However, there are some cases when descriptions are imported while updating schema:

  1. New object (table/view/procedure/function) - if a new table was added to the database, update behaves exactly as first import - table is imported with its descriptions as new.
  2. New element (column/parameter) - a new column or parameter was detected in the database, it is read just as a new object and description from DBMS is imported with it.
  3. Empty description in the repository - if the description of object or element is empty in the repository, Dataedo will read descriptions from DBMS and insert it into the repository.
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.
There are no comments. Click here to write the first comment.