From: Scott Marlowe <scott.marlowe@gmail.com>
To: Hajek, Nick <Nick.Hajek@vishay.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Database Conversion
Date: Thu, 4 Sep 2008 10:27:33 -0600
Message-ID: <dcc563d10809040927x6d9ea5e1m28b89678a0ef4051@mail.gmail.com> (raw)
In-Reply-To: <AFD16ED07E37C64D963DA24840AA31F2043747AD@EVSCO01.na.vishayint.com>
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.
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: scott.marlowe@gmail.com, Nick.Hajek@vishay.com
Subject: Re: Database Conversion
In-Reply-To: <dcc563d10809040927x6d9ea5e1m28b89678a0ef4051@mail.gmail.com>
* 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