Documentation

Table of Contents:


    MySQL support

    2017-12-21
    Applies to: 6.x, Article available also for: 7.x (current), 5.x
    You are looking at documentation for an older release.
    Switch to the documentation for Dataedo 7.x (current).

    Supported MySQL databases

    Versions: 5.1, 5.5, 5.6, 5.7

    Supported schema elements and metadata

    Dataedo reads following metadata from MySQL databases.

    • Tables
      • Columns
        • Data type with length
        • Nullable
        • Default value
        • Generated column formula
      • Primary keys
        • Columns
      • Unique indexes
        • Column
      • Foreign keys
        • Columns
      • Triggers
        • When triggered
        • Script
    • Views
      • Columns (see tables)
      • Script
    • Procedures
      • Script
      • Parameters (not available on MySQL 5.1)
    • Functions
      • Script
      • Parameters (not available on MySQL 5.1)
      • Returned value (not available on MySQL 5.1)

    Comments

    Dataedo reads MySQL comments from following objects:

    • Tables
      • Columns
      • Primary keys
      • Unique indexes
    • Views
      • Columns
    • Procedures
    • Functions

    Dataedo does not write comments back to MySQL.

    Limitations

    Following schema/metadata elements currently are not supported:

    • Check constraints (vote)
    • Non unique indexes (vote)
    • Dependencies - are not presented by MySQL

    Connection:

    • SSL connection is currently not supported
    Found issue with this article? Comment below
    0
    There are no comments. Click here to write the first comment.