Documentation

Table of Contents:


    Amazon Aurora MySQL support

    Piotr Tokarski - Dataedo Team Piotr Tokarski 2018-04-19 2018-08-01
    Applies to: 7.1 (current), Article available also for: 6.3, 5.2

    Supported versions

    • MySQL 5.6 compatible
    • MySQL 5.7 compatible
    • PostgreSQL compatible - check here

    Supported schema elements and metadata

    MySQL 5.6/5.7 compatible

    Dataedo reads following metadata from Amazon Aurora 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
    • Functions
      • Script
      • Parameters
      • Returned value

    Comments

    MySQL 5.6/5.7 compatibile

    Dataedo reads Amazon Aurora comments from following objects:

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

    Dataedo does not write comments back to Amazon Aurora.

    Limitations

    MySQL 5.6/5.7 compatibile

    Following schema/metadata elements currently are not supported:

    • Check constraints (vote)
    • Non unique indexes (vote)
    • Dependencies - not presented by Amazon Aurora

    Connection:

    • SSL connection is currently not supported
    Found issue with this article? Comment below
    Comments (0)