This post originated from an RSS feed registered with Ruby Buzz by Jeremy Voorhis. Original Post: Planet Argon on migration between MySQL to PostgreSQL Feed Title: JVoorhis Feed URL: http://feeds.feedburner.com/jvoorhis Feed Description: JVoorhis is a Rubyist in northeast Ohio. He rambles about Ruby on Rails, development practices, other frameworks such as Django, and on other days he is just full of snark. Latest Ruby Buzz Posts Latest Ruby Buzz Posts by Jeremy Voorhis Latest Posts From JVoorhis

My parter in crime just posted an article explaining how he migrated a production database from MySQL to PostgreSQL with a 15-line Rake task + RailsFS. RailsFS serializes each record from MySQL as YAML, which the rake task is then able to iterate over and load into the new PostgreSQL structure.

If you are interested in converting a MySQL database to PostgreSQL for an app of any sort, I recommend you talk to Planet Argon for a clean transition.