Using a MySQL database as a source in DMS Schema Conversion - Amazon Database Migration Service
MySQL to PostgreSQL conversion settings
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Using a MySQL database as a source in DMS Schema Conversion

You can use MySQL databases as a migration source in DMS Schema Conversion.

You can use DMS Schema Conversion to convert database code objects from MySQL Database to the following targets:

  • PostgreSQL

  • Aurora PostgreSQL

The privileges required for MySQL as a source are as follows:

  • SELECT ON *.*

  • SHOW VIEW ON *.*

MySQL to PostgreSQL conversion settings

For information about editing DMS Schema Conversion settings, see Specifying schema conversion settings for migration projects.

MySQL to PostgreSQL conversion settings include the following:

  • Comments in converted SQL code: Set this setting to add comments in the converted code for the action items of the selected severity and higher.

    Valid values:

    • Errors only

    • Errors and warnings

    • All messages