FromMySqlToPostgreSql is a tool, intended to make a process of migration from MySql to PostgreSql as easy and smooth as possible.
- Ease of use - the only thing needed to run this script is the PHP(CLI) interpreter.
- Accuracy of migration the database structure - FromMySqlToPostgreSql converts MySql data types to corresponding PostgreSql data types, creates constraints, indeces, primary and foreign keys exactly as they were before migration.
- In order to migrate data fast - FromMySqlToPostgreSql uses PostgreSQL COPY protocol. Note: migration of tables, containing "varbinary" or "blob" columns may be considerably slower.
- Ease of monitoring - FromMySqlToPostgreSql will provide detailed output about every step, it takes during the execution.
- Ease of configuration - all the parameters required for migration (4 parameters) should be put in one single file, which can be in either "xml" or "json" format.
- PHP (CLI) 5.4 or above.
- PDO_MYSQL support.
- PDO_PGSQL support.
- register_argc_argv should be enabled (check php.ini).
1. Create a new database.
Sample: CREATE DATABASE my_postgresql_database;
2. Download FromMySqlToPostgreSql package and put it on the machine running
your PostgreSql.
Sample: /path/to/FromMySqlToPostgreSql
3. Create configuration file in either "xml" or "json" format and put it on
the machine running your PostgreSql.
Sample: /path/to/FromMySqlToPostgreSql/config.json or /path/to/FromMySqlToPostgreSql/config.xml
Remarks:
- sample_config.json and sample_config.xml are examples of configuration file, so you can edit one of them and use for migration.
- Brief description of each configuration parameter will be found at sample_config.json and sample_config.xml
4. Run the script from a terminal.
Sample:
php /path/to/FromMySqlToPostgreSql/index.php
/path/to/FromMySqlToPostgreSql/config[.xml | .json]
5. At the end of migration check log files, if necessary.
Log files will be located in "logs_directory" folder in the root of the package.
Note: "logs_directory" will be created during script execution.
6. In case of any remarks, misunderstandings or errors during migration,
please feel free to email me
[email protected]
Current version is 1.2.1
(major version . improvements . bug fixes)
Tested using MySql Community Server (5.6.21) and PostgreSql (9.3).
The entire process of migration 59.6 MB database (49 tables, 570750 rows),
which includes data types mapping, creation of tables, constraints, indeces,
PKs, FKs, migration of data, garbage-collection and analyzing the newly created
PostgreSql database took 3 minutes 6 seconds.
FromMySqlToPostgreSql is available under "GNU GENERAL PUBLIC LICENSE" (v. 3)
http://www.gnu.org/licenses/gpl.txt.
Errors/Exceptions are not passed silently.
Any error will be immediately written into the error log file.
Big thanks to Thierry Daguin and Marcel Gsteiger for their valuable remarks.