From:       To:      
Home > Documentation > MySQL to PostgreSQL

Merging MySQL data into the PostgreSQL database

MySQL to PostgreSQL converter implements quite simple merging algorithm. If a table has primary key or an unique index, the program inserts into PostgreSQL database only those MySQL rows whose key/index value does not exist in the destination table. Otherwise, the application appends the whole MySQL table contents to the corresponding PostgreSQL table.

If the structures of source and destination tables are different, the converter transforms each record of MySQL table so that it conforms to the structure of PostgreSQL table.

Have questions? Contact us