Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 03E7464FD33
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu,  4 Sep 2008 16:42:07 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 25413-02 for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu,  4 Sep 2008 16:42:03 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from ey-out-2122.google.com (ey-out-2122.google.com [74.125.78.25])
	by postgresql.org (Postfix) with ESMTP id 3462A64FCEF
	for <pgsql-admin@postgresql.org>; Thu,  4 Sep 2008 16:42:03 -0300 (ADT)
Received: by ey-out-2122.google.com with SMTP id 6so39723eyi.61
	for <pgsql-admin@postgresql.org>; Thu, 04 Sep 2008 12:42:01 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:cc:in-reply-to:mime-version:content-type:references;
	bh=OL4DFl1uJ1rjeczZdu95M6Xc1NKFGxDnn8O9S8tFEIo=;
	b=ILYgcLh42YwDR509AD1AkMQ3ZaFM1IEMGhRGqBv1sca5ML7bK9ZTgJ6DtE9oyxtshN
	o8b8Suc09N4t5VsZCcQAdq225AVOz087sOcKOodUcWX33zzq9KlOXcIJq42mpeTd9SVo
	aN/ScbadPiefIp7Nc+xMVKNEr/9wixS6einxs=
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:references;
	b=Xq2V6c6EJq1eiOREWT77/wvl3JioZ01aaf3ajj9EDlDNXKUYg7VLYxSlRt7nAzr9oH
	v5jcfzrpJEOkE6ymRgTtIhZ3U4a9KrxjQLk6WK7sVkLU/c6vVcKBOk919AxllbMgkupH
	VizHM0V63+C1ZfjaznwYsOio2ZJ3QVb9NCpwM=
Received: by 10.210.51.10 with SMTP id y10mr12442295eby.14.1220557321021;
	Thu, 04 Sep 2008 12:42:01 -0700 (PDT)
Received: by 10.210.117.6 with HTTP; Thu, 4 Sep 2008 12:42:00 -0700 (PDT)
Message-ID: <d29515d60809041242g6c982e9bgc9edfe485bcba397@mail.gmail.com>
Date: Thu, 4 Sep 2008 15:42:00 -0400
From: "Alan Scott" <balanscott@gmail.com>
To: "Carol Walter" <walterc@indiana.edu>
Subject: Re: Database Conversion
Cc: pgsql-admin@postgresql.org
In-Reply-To: <9B852776-95B1-41E2-B6A8-DFA92F7C410F@indiana.edu>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_56054_32149002.1220557321020"
References: <9B852776-95B1-41E2-B6A8-DFA92F7C410F@indiana.edu>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200809/30
X-Sequence-Number: 30123

------=_Part_56054_32149002.1220557321020
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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
>

------=_Part_56054_32149002.1220557321020
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr">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.<br>
<br>
<div class="gmail_quote">On Thu, Sep 4, 2008 at 9:24 AM, Carol Walter <span dir="ltr">&lt;<a href="mailto:walterc@indiana.edu">walterc@indiana.edu</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hello, All,<br><br>I have a new faculty member who has a large database that is in MySQL. &nbsp;We don&#39;t support MySQL so the database needs to be ported to PostgreSQL. &nbsp;Her GA, who know MySQL, says that he has a query that he will run that will put the data into postgres. &nbsp;I thought that the data would have to be output to a text file and then copied into postgres. &nbsp;I don&#39;t know MySQL. &nbsp;I&#39;ve done a conversion from Oracle and this is how I did it. &nbsp;Is he correct that he can put the data into a postgres database by running a MySQL query? &nbsp;It doesn&#39;t sound possible to me.<br>
<br>Carol<br><font color="#888888"><br>-- <br>Sent via pgsql-admin mailing list (<a href="mailto:pgsql-admin@postgresql.org" target="_blank">pgsql-admin@postgresql.org</a>)<br>To make changes to your subscription:<br><a href="http://www.postgresql.org/mailpref/pgsql-admin" target="_blank">http://www.postgresql.org/mailpref/pgsql-admin</a><br>
</font></blockquote></div><br></div>

------=_Part_56054_32149002.1220557321020--