Overall they are very similar, but there's a variety of differences that can be very annoying.. The biggest challenge would be stored procedures, so if you use those heavily, you're in for a lot of work. Aside from that data type differences and syntax differences will be the next issue. If you are using a lot of MySQL specific functions in your SELECT SQL statements, you may have to rewrite them to PostgreSQL's version. MySQL has more data types than PostgreSQL so you'll have to change those accordingly. Oh, and if you're using MySQL's empty date & datetime values in your data, you'll need to change those to NULL instead for PostgreSQL.
-Steve At 04:20 PM 11/06/2010, you wrote: >Hi Everybody, > >How different are they? Assuming an ordinary geek who administers the >MySQL with occasional problems, is it impossible, hard or easy. > >Idea being that the license fee for MySQL is the dealbreaker. >-- >Regards, > >Pete >http://pete-theisen.com/ >http://elect-pete-theisen.com/ > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
