From: Alan Scott <balanscott@gmail.com>
To: Carol Walter <walterc@indiana.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Database Conversion
Date: Thu, 4 Sep 2008 15:42:00 -0400
Message-ID: <d29515d60809041242g6c982e9bgc9edfe485bcba397@mail.gmail.com> (raw)
In-Reply-To: <9B852776-95B1-41E2-B6A8-DFA92F7C410F@indiana.edu>
References: <9B852776-95B1-41E2-B6A8-DFA92F7C410F@indiana.edu>
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@indiana.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: balanscott@gmail.com, walterc@indiana.edu
Subject: Re: Database Conversion
In-Reply-To: <d29515d60809041242g6c982e9bgc9edfe485bcba397@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox