From: Ben Kim <bkim@tamu.edu>
To: pgsql-admin@postgresql.org
Subject: Re: Database Conversion
Date: Thu, 4 Sep 2008 09:33:37 -0500 (CDT)
Message-ID: <Pine.GSO.4.64.0809040855020.20979@coe.tamu.edu> (raw)
In-Reply-To: <200809041641.29301.achill@matrix.gatewaynet.com>
References: <9B852776-95B1-41E2-B6A8-DFA92F7C410F@indiana.edu>
<200809041641.29301.achill@matrix.gatewaynet.com>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bkim@tamu.edu
Subject: Re: Database Conversion
In-Reply-To: <Pine.GSO.4.64.0809040855020.20979@coe.tamu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox