Re: Migrate from MySQL to PostgreSQL

Hi! Andreas Korthaus wrote:

Im trying to migrate from MySQL 4.0 to PostgreSQL 7.3 I'm using PEAR::DB, so this will be no big problem. But how to get data and table-definitions to PostgreSQL? I have about 100 tables which have to be migrated. I tried to use MyODBC and pgAdmin2 migration Wizard, but this does not work (pgAdmin crashes). So I tried to change a mysqldump by myself, but this is very difficult and could cause problems which I perhaps don't see at once. So is there a better solution to migrate the table-definitions?

There is a contrib/mysql dir in PostgreSQL distribution, which contains the scripts to convert the schema. But I'd suggest reviewing and probably refactoring the schema after conversion. MySQL's limited feature set, poor support for date and time related types, lack of native boolean type sometimes lead to really poor design decisions.