On Tuesday, 17 November 2015 13:08:00 UTC, prashant sirohi wrote: > > Hi ,i am a newbie in rails and i have recently got a task on my job to > migrate the old data from a php website to new rails website.php website > data is in mysql and rails data is in postgres,i cannot find a way in which > i can transport the whole data from php to rails provided that there are > some extra fields and tables being added in rails database also the field > names are different in both tables. > > > > Can someone suggest a way to do this so that i don't have to do it > manually. >
One possible way would be to export the Mysql tables as CSV files, then import them in to your Rails app's PG database. Without knowing what your app looks like, I would probably add a rake task that uses Ruby's CSV class to read in each exported table - if you use the "headers: true" option when opening the CSV file you can then refer to each column by name. I'm assuming you have Rails models for each table - so then you do something like CSV.foreach 'some/file.csv', headers: true do | row | person = Person.create! first_name: row['first_name'], last_name: row['last_name'], email: row['email'] end -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/9d1f4d70-6a8f-478a-9e77-4ccc0e3fb51f%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
