Re: Migrating from mysql.

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: "Morten W(dot) Petersen" <morten(at)src(dot)no>
Cc: Joe Karthauser <joe(at)pavilion(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Migrating from mysql.
Date: 2000-05-25 00:00:42
Message-ID: Pine.BSO.4.10.10005241933220.21733-200000@spider.pilosoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 24 May 2000, Morten W. Petersen wrote:

> > Hi there,
> >
> > I'm migrating from MySQL to PostgreSQL and I was wondering whether someone
> > could help me match some datatypes.
>
> I'm also migrating, and would appreciate any thoughts on how to do
> it. Spesifically, if there could be any problems with functions not
> supported on the PostgreSQL and such.

Quick and extremely, and I mean, extremely, ugly code attached.
It helped me convert some database dumps from mysql to pgsql, however, I
do not even recommend fixing it much, its too damn ugly, and written as a
hack that grew out of control.

(It converts mysql database dump into something that pgsql can load. Or
something that you can manually fix up and then load).

--
Alex Pilosov | http://www.acecape.com/dsl
CTO - Acecape, Inc. | AceDSL:The best ADSL in Bell Atlantic area
325 W 38 St. Suite 1005 | (Stealth Marketing Works! :)
New York, NY 10018 |

Attachment Content-Type Size
mysql2pgsql.pl text/plain 2.4 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alex Pilosov 2000-05-25 00:08:11 Re: Re: [ANNOUNCE] PostgreSQL 7.0 a success
Previous Message Karl DeBisschop 2000-05-24 23:41:37 Re: Postgres Instability