mysql migration

hello list
i'm looking at migrating my small mysql db to postgresql and i'm having
trouble finding information an easy way to do it... any suggestions/links?

thanks

Go to:

http://techdocs.postgresql.org/ and scroll down to "Converting from
Other Databases to PostgreSQL" - there are several links there that
specifically address MySQL conversion.

Elaine

daniel wrote:

hello list
i'm looking at migrating my small mysql db to postgresql and i'm having
trouble finding information an easy way to do it... any suggestions/links?

What about

contrib/mysql/mysql2pgsql

Please keep in mind, that this is just a starting point.
However small the database you're porting from MySQL is, the
fundamental misconceptions in the MySQL design usually lead
to serious implementation errors on the application side.

Forget anything you think you learned so far from the MySQL
documentation. The MySQL development team prefers to tell
people things like "referential integrity is for
documentation purposes". You could've gotten kicked out of
your CS class for repeating such bullshit. So their
"documentation" is mainly "marketing material". It actually
doesn't have much to do with relational databases.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Le Jeudi 21 Mars 2002 00:28, daniel a écrit :

hello list
i'm looking at migrating my small mysql db to postgresql and i'm having
trouble finding information an easy way to do it... any suggestions/links?

Try pgAdmin2 (http://pgadmin.postgresql.org), it includes an odbc migration
wizard which should work with MySQL.

Cheers,
Jean-Michel POURE