Skip to main content

Updating descriptions from database

The Dataedo repository is a master data source for all descriptions. This means that once you enter a description with the Dataedo editor or import it with the 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 the schema:

  1. New object (table/view/procedure/function) - if a new table is added to the database, the update behaves exactly as the first import - the table is imported with its descriptions as new.
  2. New element (column/parameter) - a new column or parameter is detected in the database, it is read just as a new object and the description from DBMS is imported with it.
  3. Empty description in the repository - if the description of an object or element is empty in the repository, Dataedo will read descriptions from DBMS and insert them into the repository.