From: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> |
---|---|
To: | Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com> |
Cc: | mysql(at)lists(dot)mysql(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Tool for shifting tables from Mysql to Postgresql |
Date: | 2011-03-01 11:57:14 |
Message-ID: | AANLkTi=pwDnPL5XUo9z1sL8udE7RqoeO6Y-E2vvveHse@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Adarsh,
There are very good tools out for migration from Mysql to PostgreSQL.
EnterpriseDB has the migration studio which will help to migrate Mysql to
PostgreSQL.
http://www.enterprisedb.com/solutions/mysql-vs-postgresql/how-to-move-from-mysql-to-postgresql
Best Regards,
Raghavendra
EnterpriseDB Corporation
On Tue, Mar 1, 2011 at 3:57 PM, Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>wrote:
> Dear all,
>
> I want to convert some tables from Mysql database to Postgresql Database in
> Linux Systems ( Ubuntu-10.4, CentOS ).
>
> Can someone Please tell me tool for it that makes it easier.
>
> I am able to done it through FW tools in Windows System but i want to
> achieve it in Linux ( CentOS ) System.
>
> I researched a lot & tried below steps :
>
> 1. mysqldump --compatible=postgresql wiki20100130 >
> /hdd4-1/wiki20100130_mysql108feb22.sql
>
> 2. sed "s/\\\'/\'\'/g" wiki20100130_mysql108feb22.sql
>
> 3. bin/psql -Upostgres wiki20100130 <
> /hdd4-1/wiki20100130_mysql108feb22.sql
>
> invalid byte sequence for encoding "UTF8": 0xe3ba27
> HINT: This error can also happen if the byte sequence does not match the
> encoding expected by the server, which is controlled by "client_encoding".
> ERROR: invalid byte sequence for encoding "UTF8": 0xee6c65
> HINT: This error can also happen if the byte sequence does not match the
> encoding expected by the server, which is controlled by "client_encoding".
> ERROR: invalid byte sequence
>
>
> I think a tool would ease that work.
>
> Thanks & best Regards,
>
> Adarsh Sharma
>
> --
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jaiswal Dhaval Sudhirkumar | 2011-03-01 12:14:05 | Re: Tool for shifting tables from Mysql to Postgresql |
Previous Message | Mahdi Mankai | 2011-03-01 11:08:17 | Re: Issues with imported blobs from Postgres 8 to 9 |