Importing descriptions from database

When importing schema, Dataedo also reads descriptions and comments from DBMS. Those descriptions are inserted into description fields in the Dataedo repository.

Once imported, Dataedo is a master data source for descriptions and comments from DBMS are ignored. An exception is when the description is blank in the Dataedo repository. Read more in the updating descriptions article.

Database support

Dataedo reads the following descriptions/comments from DBMS:

SQL Server/Azure SQL Database:

Dataedo reads MS_Description extended property from the following SQL Server objects:

• Tables
  • Columns
  • Primary/unique keys
  • Foreign keys
  • Triggers
• Views
  • Columns
• Procedures
  • Parameters
• Functions
  • Parameters

Oracle:

Dataedo reads comments from the following Oracle objects:

• Tables
  • Columns
• Views

MySQL, MariaDB Server:

Dataedo reads comments from the following MySQL objects:

• Tables
  • Columns
  • Primary/unique keys
• Views
  • Columns
• Procedures
• Functions