Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] MySQL -> Postgres dump converter

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: lockhart(at)fourpalms(dot)org
Cc: fonin(at)ziet(dot)zhitomir(dot)ua, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] MySQL -> Postgres dump converter
Date: 2001-01-24 16:06:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Can someone look at both versions and merge the improvements into our
version?  Should be pretty easy.

> > Can some PostgreSQL people comment on this?  This person wrote a
> > MySQL->PostgreSQL converter too.  His version is at:
> >
> Hmm. My version does not have this feature, but it could be added ;)
> Seriously, I haven't looked at the differences, but there is a licensing
> difference (BSD vs GPL). Someone else with experience with MySQL should
> evaluate both packages.
> mysql2pgsql has been used to convert SourceForge, with ~90 tables and
> moderately complicated schema, but that did not include enumerated types
> (done with ints at SF) and "unique" keys (done with sequences at SF)
> afaicr.
> > Sucks found:...
> Each is a one-liner to fix in mysql2pgsql. The (nonstandard) types
> mentioned weren't used in the test cases I had available. I didn't
> realize that we had *any* reports of troubles or lacking features in the
> existing converter, but I'll leave it up to y'all to decide if the
> licensing issues and feature issues are significant.
> I'm willing to provide patches to address some of the concerns, but of
> course will not be able to look at the GPL'd code for hints and can only
> use the information posted here to help afaik.
> Comments?
>                    - Thomas

  Bruce Momjian                        |
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to


pgsql-hackers by date

Next:From: Peter EisentrautDate: 2001-01-24 16:10:19
Subject: Re: MySQL has transactions
Previous:From: Bruce MomjianDate: 2001-01-24 16:02:23
Subject: Re: Open 7.1 items

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group