mysql2postgresql
Converter mysql schema and data to postgresql
Usage
- Create dump in xml format using command:
mysqldump --xml -u USER_NAME DB_NAME > DUMP_FILE_NAME
- 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
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