Re: Mysql migration to Postgresql

this was a very general question.

you can use any ETL / script to transfer data from mysql to postgres.

for me, sometimes, the following path works:

1. first try to dump the mysql database SQL schema in ANSI-conformant
format (consult mysql support how to do it).
import this into fresh postgres dataabase.

2. if 1 works, then dump data from mysql using INSERT statements
(consult mysql support how to do it), and run these in postgres.

you can ask here if you have any postgres specific problems/questions.

2009/11/25 mrciken <mik(dot)wen(at)yahoo(dot)com>:
>
> Hello,
>
> Currently, we are using Mysql: we would like to change. Now, we would like
> to use Postgresql. Only problem is that most of our customer addresses and
> other information are on Mysql.
> Can you help us with this?
>
> Thank you.
>
> --
> View this message in context: http://old.nabble.com/Mysql-migration-to-Postgresql-tp26513373p26513373.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
Filip Rembiałkowski
JID,mailto:filip(dot)rembialkowski(at)gmail(dot)com
http://filip.rembialkowski.net/