RedGage

Every database specialist recognizes PostgreSQL and MySQL as popular open source database management systems. Both DBMS are supplied withlot of administration and development toolsand have huge communities of fans. However, PostgreSQL is more suitable for deploying corporate data warehouses due to some important features missing in MySQL:

• full compliance with the ANSI SQL standard
• support for bothsynchronous and asynchronous replication
• multipleconcepts of indexing
• asynchronous commit

These advantages force many companiestomigrate their databases from MySQL to PostgreSQL. The procedure of database migration is usually implemented according to extract-transform-load (ETL) concept that consists of the following steps:

• Export MySQL table definitionsin formof DDL SQL statements
• Process the exported statements with respect to safe type mapping, naming rulesand default values validation
• Load the converted statements into PostgreSQL database
• Export MySQL data into comma separated values (CSV) files
• Transform the exported data according toPostgreSQL ranges of accepted values and format of text representation for the appropriate data types
• Load the output CSV data into the target database
• Extractviews, triggers, and stored procedures from MySQL database asCREATE-statements and the source code
• Port these statements and source code into PostgreSQL format and import it into the destination database

The steps of ETL process listed above prove that database migration can take a lot of resources when doing it manually. Also, there is high risk of data loss or corruption due to human errors. In view of these facts it is reasonable to use database migration tools. This special software helps to avoid errors, to keep data integrity and to automate the migration process.

Intelligent Converters, a software vendor specializing in database conversion, migration and synchronization since 2001, developed one of the most popular tools for database migration from MySQL to PostgreSQL.It has great performance due to direct reading and writing of data without using middleware libraries or components.

MySQL to PostgreSQLconverter works with all versions of MySQL and PostgreSQL running on Linux/Unix/Windows platforms including such forks as MariaDB, Perconaand PaaS variations as Heroku, Amazon RDS and Google Could. For automation purposes the product supports command line parameters.Other features ofMySQL to PostgreSQL converter:

• filtering particular records for conversionthrough ‘Select’ queries
• merging or synchronizing PostgreSQL database with MySQL data
• customization of tables (renaming, changing type and attributes or excluding columns from migration)
• exportingMySQL database into SQL script

The feature at the bottom of list is designed for those cases when direct connection to PostgreSQL server is not available.Later thescript can be importedto PostgreSQL using pgAdmin or psql tools.

Learn more about MySQL to PostgreSQL converter at: https://www.convert-in.com/mysql-to-postgres.htm