Quick script to use the ar_dbcopy gem for moving data between databases.

database_copy.rb

##
# Script to copy over data from mysql to postgres
#
#   gem install ar_dbcopy --ignore-dependencies
#
# db_copy.yml needs to look like:
#
#  source:
#    adapter: mysql
#    host: localhost
#    username: root
#    password:
#    database: bloomfire_dev
#
#  target:
#    adapter: postgresql
#    host: localhost
#    username:
#    password:
#    database: bloomfire_dev
##
require 'rubygems'
require 'mysql'
require 'pg'
require 'ar_dbcopy'

ARDBCopy.new("db_copy.yml").run!