mySQL to PosgreSQL Convertor
| New Articles |
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..




