I’ve now got a tool (almost complete) that slurps in a MySQL DB definition and spits out one for Postgres. I will post a link to it when I get creation of the enum tables working. (Instead of enums, Postgres uses constraints and extra tables.)
www.percona.com/remoteDBA Have the My SQL experts administer your databases. Fixed monthly cost.
www.cisco.com/go/datacenterapps Cisco UCS w/Intel® Xeon®, an Ideal Platform for MS Exchange, See How!
www.voltdb.com/ Get the facts: OldSQL vs NoSQL vs NewSQL -- see the archived webcast
www.gigaspaces.com/Cloudify-Free Deploy, Manage & Scale in the cloud No code changes. Download free!
Eric Hodel has written 3 entries about this goal
I just rewrote all our in-code SQL queries to be easily recognizable. They now all live in
FOO = <<-SQL
WHERE x = 1
This will help us with moving away from MySQL.
Bob has also been exploring Postgres performance, but his results are preliminary