>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
