On Tue, Sep 30, 2008 at 10:08 AM, Sean Davis <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
