Re: Database Conversion

What version of Postgres? We have 8.3 and have been using Migration Studio
from Enterprise DB (which is part of the Advanced Server install). Also,
with MySQL 5.0 and above they have some conversion tools that do come with
the install to assist you.

On Thu, Sep 4, 2008 at 9:24 AM, Carol Walter <walterc(at)indiana(dot)edu> wrote:

> Hello, All,
>
> I have a new faculty member who has a large database that is in MySQL. We
> don't support MySQL so the database needs to be ported to PostgreSQL. Her
> GA, who know MySQL, says that he has a query that he will run that will put
> the data into postgres. I thought that the data would have to be output to
> a text file and then copied into postgres. I don't know MySQL. I've done a
> conversion from Oracle and this is how I did it. Is he correct that he can
> put the data into a postgres database by running a MySQL query? It doesn't
> sound possible to me.
>
> Carol
>
> --
> 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
>