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 <[EMAIL PROTECTED]>
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
