Documentation

Table of Contents:


    Importing descriptions from database

    2018-06-16

    When importing schema, Dataedo also reads descriptions and comments from DBMS. Those descriptions are inserted into description fields in 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 Dataedo repository. Read more in updating descriptions article.

    Database support

    Dataedo reads following descriptions/comments from DBMS:

    SQL Server/Azure SQL Database:

    Dataedo reads MS_Description extended property from following SQL Server objects:

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

    Oracle:

    Dataedo reads comments from following Oracle objects:

    • Tables
      • Columns
    • Views

    MySQL, MariaDB Server:

    Dataedo reads comments from following MySQL objects:

    • Tables
      • Columns
      • Primary/unique keys
    • Views
      • Columns
    • Procedures
    • Functions
    Found issue with this article? Comment below
    Comments (0)