Thread: Mysql to Postgresql

Mysql to Postgresql

From

alfred

Date:

11 October 2013, 15:02:16

Hi i want to convert mysql to postgresql ,
any free tools available?. Is it possible to convert manually. Please
guide me

best regards

Alfred

Re: Mysql to Postgresql

From

Payal Singh

Date:

11 October 2013, 17:00:51

Hey,

There are a couple of free tools to convert mysql dumps to postgresql dumps. Although these do not cater to functions and stored procedures. They will need to be converted manually. For the rest, you can have a look at:

https://github.com/ahammond/mysql2pgsql (Perl)

http://rubygems.org/gems/mysql2psql (Ruby)

https://pypi.python.org/pypi/py-mysql2pgsql (Python)

There are many other such tools available on github. All the best!

Payal Singh,
OmniTi Computer Consulting Inc.
Junior Database Architect,
Phone: 240.646.0770 x 253

On Fri, Oct 11, 2013 at 8:02 AM, alfred <alfred@arrivusystems.com> wrote:

Hi i want to convert mysql to postgresql ,
any free tools available?. Is it possible to convert manually. Please guide me

best regards

Alfred

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin