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(dot)Hajek(at)vishay(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin