Regarding migrations?

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.

···

--
Posted via http://www.ruby-forum.com/.

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.

Ravi Katta wrote:

    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.

···

--
   Phlip