Re: MySQL to Postgresql schema conversion

On Tue, Sep 30, 2008 at 10:08 AM, Sean Davis <sdavis2@mail.nih.gov> wrote:
> There are a number of mysql to postgresql converters available, but
> many of them have significant shortcomings.  Has anyone found a tool
> that works well?  I am trying to convert a couple of relatively large,
> public schema to postgresql.

I started playing with sqlalchemy (python) which can reflect a schema
to python objects.  Those objects can then be used to instantiate
another schema in a different database dialect.  Works like a charm
after modifying a couple of column names.  It mirrors about 4000
tables in about 45 seconds (of course, without the data).

Sean