Using MySQL as a source for AWS SCT - AWS Schema Conversion Tool

Using MySQL as a source for AWS SCT

You can use AWS SCT to convert schemas and application code from MySQL to the following targets:

  • Amazon RDS for PostgreSQL

  • Amazon Aurora (PostgreSQL)

  • Amazon RDS for MySQL

  • Amazon Aurora (MySQL)

For more information, see the following sections:

Privileges for MySQL as a source database

The privileges required for MySQL as a source are listed following:

  • SELECT ON *.*

  • SELECT ON mysql.proc

  • SHOW VIEW ON *.*

Connecting to MySQL as a source database

Use the following procedure to connect to your MySQL source database with the AWS Schema Conversion Tool.

To connect to a MySQL source database

  1. In the AWS Schema Conversion Tool, choose Connect to MySQL.

    
                            Connect to source database

    The Connect to MySQL dialog box appears.

    
                            MySQL connection information
  2. Provide the MySQL source database connection information. Use the instructions in the following table.

    For this parameter Do this
    Server name

    Enter the DNS name or IP address of your source database server.

    Server port

    Enter the port used to connect to your source database server.

    User name and Password

    Enter the user name and password to connect to your source database server.

    Note

    AWS SCT uses the password to connect to your source database only when you create your project or choose the Connect to source option in a project, where source is your source database. To guard against exposing the password for your source database, AWS SCT doesn't store the password. If you close your AWS SCT project and reopen it, you are prompted for the password to connect to your source database as needed.

    Use SSL

    Select this option if you want to use SSL to connect to your database. Provide the following additional information, as appropriate, on the SSL tab:

    • Require SSL: Select this option if you want to connect to the server only through SSL.

      Note

      If you choose Require SSL, it means that if the server doesn't support SSL, you can't connect to the server. If you don't choose Require SSL and the server doesn't support SSL, you can still connect to the server without using SSL. For more information, see Using secure connections.

    • Verify Server Certificate: Select this option to verify the server certificate by using a trust store.

    • Trust Store: The location of a trust store containing certificates.

    • Trust Store Password: The password for the trust store.

    Store Password

    AWS SCT creates a secure vault to store SSL certificates and database passwords. Enabling this option lets you store the database password and to connect quickly to the database without having to enter the password.

    MySql Driver Path

    Enter the path to the driver to use to connect to the source database. For more information, see Installing the required database drivers.

    If you store the driver path in the global project settings, the driver path doesn't appear on the connection dialog box. For more information, see Storing driver paths in the global settings.

  3. Choose Test Connection to verify that you can successfully connect to your source database.

  4. Choose OK to connect to your source database.