Re: Migrate Mysql to Posgresql

>Hello,
>
>I want to migrate my MySql databases to Postgresql.
>
>Does anyone know how to do that ???
>
>Thanks for you help
>
>Olivier
>

Olivier,

1 - Export the database structure and data to a series of textfiles,
load your favorite texte editor and modify the scripts to match
PostGres definitions. Create the database under Postgres from the
scripts and import the data.

2 - You can download PGAdmin for Windows. It has a migration wizard
from mdb, odbc. If you have the MySQL odbc driver, you can migrate
from MySql to Postgres very easely. 

Best regards.

Alain