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

Popular posts from this blog

python - Scipy curvefit RuntimeError:Optimal parameters not found: Number of calls to function has reached maxfev = 1000 -

c# - How to add a new treeview at the selected node? -

java - netbeans "Please wait - classpath scanning in progress..." -