database - Rails: transfer data from one schema to another -
i'm migrating php app rails. new app has different schema.
anybody have experience data 1 schema another? right now, i'm looking @ dumping csv files , writing ruby scripts handle insertion on other side. i've considered using navicat export/import temp database new schema (if it's simple enough), dump database , insert values new database using db:seed.
i figure gonna total pain whichever way go -- hoping minimize angst. in advance!
update:
decided export navicat xml, use nokogiri create seed files seed_fu.
check out dr. nic's magic model gem. http://magicmodels.rubyforge.org/dr_nic_magic_models/
then use rake tasks iterate through csvs , insert using newly generated models.
Comments
Post a Comment