Re: Database Conversion

Well, my database server lives on a Solaris 10 box. I'm running
PosgreSQL 8.2.3. The database that is being converted from MySQL is
currently on a Windows machine. So far it seems that every solution
involves an interim step or two. I think he was alluding to just
running a query.

Carol
On Sep 4, 2008, at 10:33 AM, Ben Kim wrote:

>
>> 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
>
> --
> 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