Date: Thu, 4 Sep 2008 09:33:37 -0500 (CDT)
From: Ben Kim <bkim@tamu.edu>
To: pgsql-admin@postgresql.org
Subject: Re: Database Conversion
In-Reply-To: <200809041641.29301.achill@matrix.gatewaynet.com>
Message-ID: <Pine.GSO.4.64.0809040855020.20979@coe.tamu.edu>
References: <9B852776-95B1-41E2-B6A8-DFA92F7C410F@indiana.edu>
	<200809041641.29301.achill@matrix.gatewaynet.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed


> 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