Convert MySQL to PostgreSQL, MySQL to PostgreSQL converter, mysql2postgres, sql, postgres, free download
FAQ  |  Site map  |  Contact Us
About Us How to Buy Products Discounts Migration Service Support Become a Partner Articles

MySQL to PostgreSQL

MySQL-to-PostgreSQL is a program to migrate PostgreSQL databases to MySQL server. The program has high performance due to direct connection to data source and destination databases. It does not use ODBC or any other middleware software. Command line version of the tool allows to script and schedule the conversion process.

Features
  • MySQL to PostgreSQL works with all versions of MySQL (including its forks MariaDB and Percona) and PostgreSQL (including Heroku)
  • The program converts indexes and foreign keys with all necessary attributes
  • Fast conversion engine (about 20,000 records per second on average modern system)
  • Option to export into SQL script file
  • Option to customize name, type, default values for every column
  • Option to synchronize PostgreSQL database with MySQL data
  • Option to select MySQL tables for conversion
  • Option to filter data using SELECT-queries
  • Support for Unicode
  • Command line support
  • Stores conversion settings into profile
  • Quick Launch
  • Easy-to-use wizard-style interface
  • Full install/uninstall support
  • Unlimited 24/7 support service
  • 1-year subscription for updates

Limitations

  • Does not convert views, stored procedures and triggers
  • Demo version converts only 50 records per table
  • Demo version does not convert foreign keys
    

Download trial version of MySQL-to-PostgreSQL

Requirements

  • PostgreSQL environment (server or client components of PostgreSQL must be installed on the same machine where you run MySQL to PostgreSQL converter)
  • Necessary privileges to write into the destination database

Quick Lauch

Once you stored conversion settings into profile you can run the converter in Quick Launch mode. Just launch Windows Explorer and double-click on the profile description (.s2p) file with left mouse button. Then MySQL to PostgreSQL conversion will be launched loading the necessary settings from the specified profile.

Synchronization

MySQL to PostgreSQL converter implements synchronization as combination of insert MySQL records that are missing in PostgreSQL table and update existing PostgreSQL records with MySQL data. For synchronization purpose source and destination tables must have identical structures and have primary key or unique index defined. Assume both MySQL and PostgreSQL databases have table "People" defined as below:

    People(
	ID INT NOT NULL, 
	FName VARCHAR(50),
	LName VARCHAR(50), 
	EMail VARCHAR(50), 
        Primary Key (ID)
    );

This table has the following contents in MySQL database:

    2	Andrew		White		a.white@corporation.com
    3	Phil		Johnson		p.johnson@gmail.com

In PostgreSQL database:

    1	John		Smith		j.smith@msn.com
    2	Andrew		White		a.white@yahoo.com

After synchronizing PostgreSQL table with MySQL data, the source table is kept untouched and PostgreSQL table is modified as (pay attention to the 2nd row):

    1	John		Smith		j.smith@msn.com
    2	Andrew		White		a.white@corporation.com
    3	Phil		Johnson		p.johnson@gmail.com

PostgreSQL script file

MySQL to PostgreSQL converter allows users to migrate MySQL database into PostgreSQL format even when there is no connection to PostgreSQL server available for some reason. Following this way, the program converts MySQL data into a local PostgreSQL script file instead of migrating it to PostgreSQL server directly. The resulting file contains PostgreSQL statements to create all tables and to fill them with the data. Click here to learn how to import dump file into PostgreSQL database.

Try before you buy

Still not sure MySQL to PostgreSQL converter fits your needs? Try free demo version with limited features. It converts only 50 records for each database table and it does NOT convert queries/views and foreign keys. Test the quality of the demo and come back to place an order if satisfied with the results.

Download trial version of MySQL-to-PostgreSQL

 

MySQL-to-PostgreSQL
order single product
$49 ORDER NOW
MySQL Migration Toolkit
software pack to convert any data source to MySQL
and vice versa
$99 ORDER NOW
Postgres Migration Toolkit
software pack to convert any data source to PostgresSQL
and vice versa
$99 ORDER NOW