Re: Database Conversion - Mailing list pgsql-admin

From Ben Kim
Subject Re: Database Conversion
Date
Msg-id Pine.GSO.4.64.0809040855020.20979@coe.tamu.edu
Whole thread Raw
In response to Re: Database Conversion  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: Database Conversion  (Carol Walter <walterc@indiana.edu>)
List pgsql-admin
> 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.

I don't think mysql has anything that exports data into postgresql. Unless
he is talking about the likes of DTS/SSIS or perl DBI, or other tools. Or
the tables are simple and he thinks he can ingeniously craft queries and
run them through pipes eventually to psql. DDL will be more difficult.


Regards,
Ben

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: server/db encoding (mix) issues
Next
From: Carol Walter
Date:
Subject: Re: Database Conversion