Postgres Pro
Downloads
Home   >   mailing lists

Thread: mysql migration

mysql migration

From
"daniel"
Date:
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

Re: mysql migration

From
Elaine Lindelef
Date:
>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

Re: mysql migration

From
Jan Wieck
Date:
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

Re: mysql migration

From
Jean-Michel POURE
Date:
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