Home > Documentation > PostgreSQL to MySQL

Merging PostgreSQL data into MySQL database

PostgreSQL to MySQL converter allows to merge data into exsiting database according to the following algorithm. If a table has primary key or an unique index, the program inserts into MySQL database only records with key/index value not exist in the destination table. Otherwise, PostgreSQL-to-MySQL appends the whole table contents to the corresponding MySQL table. If the structures of source and destination tables are different, the program transforms each record of PostgreSQL table so that it conforms to MySQL table structure.

If structures of PostgreSQL and MySQL tables are distinguished, the converter attempts to transform every row so that it conforms to MySQL Server table structure.

Have more questions? Contact us