Re: Database Conversion

According to the GA, the database has 1,000,000 rows.  I hesitate to
pass that along because I don't know what that means.  It strikes me
as an odd way to talk about a relational database.  Normally, a
relational database has more than one table, so how is a "database"
having a million rows relevant.  There are other databases in other
research projects, that have main tables that has well more than a
million records, so I don't know if this is considered large or not.

I thank you, all, for your answers.

Carol

On Sep 4, 2008, at 12:27 PM, Scott Marlowe wrote:

> 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.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin