On Jul 24, 2005, at 1:16 PM, John DeSoi wrote:
> On Jul 24, 2005, at 12:59 PM, Michael Avila wrote:
> > If anyone has any info about how to convert MySQL to PostgreSQL
> > PLEASE let
> > me know!
> I have not tried it, but there is such a utility here:
I have tried it, and it does about 99% of the job. There are a few
things that are MySQL version-dependent (added in later mysql versions)
that sqlfairy doesn't deal with appropriately, but those can usually be
dealt with by a simple find/replace in the word processor or a
perl/awk/sed script. If you are a perl user, sqlfairy is also called
SQL::Translator on cpan.
As an alternative, look in the postgresql distribution in
/contrib/mysql. There are two scripts for doing the conversion there.
Hope this helps.
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2005-07-24 17:45:51|
|Subject: Re: Create a row-wise conditional view |
|Previous:||From: John DeSoi||Date: 2005-07-24 17:16:54|
|Subject: Re: Utility to Convert MySQL to PostgreSQL|