From:       To:      

Home > Documentation > MySQL to PostgreSQL > Tutorial

Step 4 of 6. Select Databases

On this wizard page the source MySQL, MariaDB or Percona database and the destination PostgreSQL database or script file must be specified. Existing PostgreSQL database can be processed according to one of the following options:

  • Overwrite the entire database
  • Overwrite existing tables only
  • Skip existing tables
  • Merge
  • Synchronize

Existing PostgreSQL script file will be overwritten. Also, there are conversion settings to customize:

  • Convert table definitions only - select this checkbox to convert only table definitions of MySQL database. All the data will not be migrated.
  • Skip converting indexes - select this checkbox if you don't want to convert indexes
  • Make names case sensitive - select this checkbox to make table and column names case sensitive. Such names must be enclosed in quotes when composing query.

Have questions? Contact us