Migrate from MySQL to PostgreSQL

From: Date: Fri, 23 Jan 2004 06:06:34 +0000
Subject: Migrate from MySQL to PostgreSQL
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-10302@lists.php.net to get a copy of this message
Hi! 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? I thougt about PEAR::MDB, is there a way to create an XML-table-definition for MDB, by MDB itself? I could not find any methodes which could do something like that. What could I do? Any ideas? kind regards, Andreas

« previous php.pear.general (#10302) next »