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.
Best Regards,
Raghavendra
EnterpriseDB Corporation
Raghavendra
EnterpriseDB Corporation
On Tue, Mar 1, 2011 at 3:57 PM, Adarsh Sharma <adarsh.sharma@xxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
