DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=KOB8359Sgqg8aLQZ2GO7rA9Z56gAyWWlC5G2BdkU/CAYSPvkwYls93h4YqCHCZY70J
	hPrQzJmuJ4bY0Qwi5NKr3Rw3RfYmwKX10IdSSn4lkaTphFipijF2v3bz1GNtJJP+egAM
	EKknsmhSdMBLhgxRXatOIzMBi/CQoet30JhbQ=
Message-ID: <dcc563d10809040927x6d9ea5e1m28b89678a0ef4051@mail.gmail.com>
Date: Thu, 4 Sep 2008 10:27:33 -0600
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "Hajek, Nick" <Nick.Hajek@vishay.com>
Subject: Re: Database Conversion
Cc: pgsql-admin@postgresql.org
In-Reply-To: 
 <AFD16ED07E37C64D963DA24840AA31F2043747AD@EVSCO01.na.vishayint.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <9B852776-95B1-41E2-B6A8-DFA92F7C410F@indiana.edu>
	<AFD16ED07E37C64D963DA24840AA31F2043747AD@EVSCO01.na.vishayint.com>

On Thu, Sep 4, 2008 at 9:22 AM, Hajek, Nick <Nick.Hajek@vishay.com> 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
>>
>
> You could possibly do it in a single operation using MS Access if you
> have an ODBC connection to each database.  If however the dataset is
> large, I wouldn't recommend it.  I have a number of MySQL and PostgreSQL
> dbs and I either dump sql and then import or use PHP scripts when moving
> between the two.

Also, if you can spare the afternoon to learn it, sed is an awesome
tool for ETL.  I've used it for migrating stuff from oracle to pgsql
and mangling input data to work.