Re: mysql migration - Mailing list pgsql-general

From Jan Wieck
Subject Re: mysql migration
Date
Msg-id 200203210231.g2L2Vtg11803@saturn.janwieck.net
Whole thread Raw
In response to mysql migration  ("daniel" <dan@netgenetix.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "Samuel J. Sutjiono"
Date:
Subject: Re: How does Index Scan get used
Next
From: Jan Wieck
Date:
Subject: Re: Postmaster processes running out of control?