Regarding migrations?

[Ravi Katta]

Hi,

I am using "review_old" database in my rails app.i have 20 tables in
"review_old" database.
some people already written some reviews on "review_old" database.

But i have changed one filed in one table.And i have created new
database with name "review_new".

how to migrate data "review_old" to "review_new"

please give me solution without losing one record i should create new
database with changes.


thanks,
Ravi.

 

[phlip]

You will get the best answers on Rails topics here:

news://news.gmane.org:119/gmane.comp.lang.ruby.rails

Ruby is the language that supports Rails, so its forum is less well qualified to
cover all the juicy Railsey details. Do not take the following answer as canon
so much as me showing off. Do not post your followup question here.

I am using "review_old" database in my rails app.i have 20 tables in
"review_old" database.
some people already written some reviews on "review_old" database.

But i have changed one filed in one table.And i have created new
database with name "review_new".

how to migrate data "review_old" to "review_new"

please give me solution without losing one record i should create new
database with changes.

Look up "Rails migrations". You should never clone a database just to add a
field. Oracle DBAs do that. An ActiveRecord migration will insert the field
without affecting the existing data.