mysqldump export and pg_dump import

From: Alberto Otero García <alberto(at)cometatech(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: mysqldump export and pg_dump import
Date: 2000-11-01 11:34:59
Message-ID: 39FFFFE3.7B64F433@cometatech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Hello everybody,

We have a MySQL database, and we're planning to migrate all to a PostgreSQL
database. We must migrate all the data to a development system, in order to
take real performance numbers. The problem is we don't know how to convert the
files generated by mysqldump in order to import them with pg_dump (and have
therefore the same tables and data).

Does anybody done this before?
Is there any script to automate the process?

Please, send the answer with a CC to my personal address
(alberto(at)cometatech(dot)com) since I'm not already subscribed to the mailing list.

Thank you very much in advance for your help.

--
Alberto Otero García e-mail: alberto(at)cometatech(dot)com
Cometa Technologies, S.L. URL: http://www.cometatech.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave 2000-11-01 12:07:04 Does column header support multibyte character?
Previous Message Poul L. Christiansen 2000-11-01 10:16:58 Re: Query caching

Browse pgsql-novice by date

  From Date Subject
Next Message Eduardo Kotujansky 2000-11-01 13:13:29 Re: [SOLUTION ]pg_hba.conf , problem......
Previous Message Eduardo 2000-11-01 10:52:16 pg_hba.conf , problem......