Re: Database Conversion

I'm using 8.2.3. I don't know which version of MySQL the faculty
member has her database in.

I really appreciate all the helpful suggestions. This seems like a
very interesting topic.

Carol
On Sep 4, 2008, at 3:42 PM, Alan Scott wrote:

> 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
>