Thread: Help-me, please!

-----Original Message-----
From: Leandro Engel [mailto:leandroengel@uol.com.br]
Sent: 23 October 2002 14:27
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Help-me, please!

Hi,

 

How do I to do the migration from MySQL to Postgre ?
When I open the menu Plugins -> 'Database Migration Wizard' just show
ODBC, Access or SQL Server database.
I need do it with MySQL.
Thanks.

 

Leandro Engel

Brazil

Hi Leandro,

just look at [postgresql-source]/contrib/mysql

there are 2 scripts to translate mysql schema and
data to postgresql.

Here is the README in that directory:

Here are two conversion utilities for MySQL dumps.  Use the one you prefer.

The most recent version of my2pg.pl can be obtained from:

        http://ziet.zhitomir.ua/~fonin/code/

Another tool, mysql2pgsql,  can be found at:

        http://www.rot13.org/~dpavlin/sql.html


HTH
Tino Wildenhain

--On Mittwoch, 23. Oktober 2002 11:27 -0200 Leandro Engel
<leandroengel@uol.com.br> wrote:

>
> Hi,
>
> How do I to do the migration from MySQL to Postgre ?
> When I open the menu Plugins -> 'Database Migration Wizard' just show
> ODBC, Access or SQL Server database.
> I need do it with MySQL.
> Thanks.
>
> Leandro Engel
> Brazil