kluevandrew/mysql2postgresql

Mysql XML to Postgresql Sql dump converter

1.0.4 2016-06-30 09:31 UTC

Requires

• ext-pgsql: *

GPL-2.0

• Andrew Kluev

README

Converter mysql schema and data to postgresql

Usage

1. Create dump in xml format using command: mysqldump --xml -u USER_NAME DB_NAME > DUMP_FILE_NAME
2. Run converter using command: php convertor.php -i DUMP_FILE_NAME -o PSQL_FILE_NAME

Additional options

• -b50 - set batch count (used on insert data). By default batch count = 200
• -n - non export structure

Restriction

This converter does not support foreign keys, because mysql does not return foreign key in xml dump Also You must have installed locally php postgresql extension