mySQL to PosgreSQL Convertor

New Articles

A comparision of SQL Numeric types.

PHP FTP Client.

Perl Mysql and Blobs

Moving your database from mySQL to Postgres

It's about time that you considered moving across to postgresql. Postgresql is a superior database in many ways not the least of which is their license terms. This web convertor is intended to help you convert your database creation script from mysql to a format that is compatible with Postgresql.

Invoke the mysqldump program to generate the SQL that was used to create your set of tables. The current version of the convertor cannot migrate your data at the moment so invoke mysqldump as follows:

mysqldump database -uusername -p --no-data > tables.sql

Cut and paste the contents of tables.sql into the form below. The convertor will generate the equivalent SQL script for use in postgres.

 


Though this script has seen quite a bit of testing and use it's possible that the generated SQL may have some incompatibilities. If this happens to you, please contact the author..