Re: Database Conversion

From: Carol Walter <walterc(at)indiana(dot)edu>
To: "H(dot) Hall" <hhall1001(at)reedyriver(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database Conversion
Date: 2008-09-04 17:28:14
Message-ID: 7EF858BE-FCBC-4579-993C-8A1FBAE7A735@indiana.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

That's a good idea. I think I'll try that.

Carol

On Sep 4, 2008, at 1:18 PM, H. Hall wrote:

> Carol Walter 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
>>
> Why don't you crate a schema for him and let him try out his idea.
> What's the downside?
>
> The upside is that we all may learn something new.
>
> HH
>
> --
> H. Hall
> ReedyRiver Group LLC
> http://www.reedyriver.com
>
>
> --
> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Alan Scott 2008-09-04 19:42:00 Re: Database Conversion
Previous Message H. Hall 2008-09-04 17:18:07 Re: Database Conversion