kluevandrew/mysql2postgresql

Mysql XML to Postgresql Sql dump converter

Maintainers

Details

github.com/kluevandrew/mysql2postgresql

Source

Installs: 22

Dependents: 0

Suggesters: 0

Security: 0

Stars: 1

Watchers: 2

Forks: 40

Type:project

1.0.4 2016-06-30 09:31 UTC

Requires

  • ext-pgsql: *

GPL-2.0 c6efab657389c5783edfb370618fa697722d7aae

  • Andrew Kluev <a.kluev.woop@php73.ru>

This package is auto-updated.

Last update: 2024-04-29 03:18:23 UTC

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