Re: Mysql to Postgresql

From: Payal Singh <payal(at)omniti(dot)com>
To: alfred <alfred(at)arrivusystems(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Mysql to Postgresql
Date: 2013-10-11 14:00:22
Message-ID: CANUg7LDH_rqNRbCvBy7p7PWQ6X1X8jpbra5zd1+ff380vaEBOg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)arrivusystems(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-admin<http://www.postgresql.org/mailpref/pgsql-admin>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Marc Fromm 2013-10-11 16:53:30 Re: convert from latin1 to utf8
Previous Message alfred 2013-10-11 12:02:00 Mysql to Postgresql