Rails migration in non-Rails projects.

Install Ruby 1.9 and your database adapter (e.g. gem install pg) then:

gem install "dbmigrator"

This gems allows only migrate the existing database. We turned off db:create and db:drop due to security issues.

To create migration you should use the folling command:

rake db:migrations:new GROUP=items NAME=add_new_column

This command creates migration with name add_new_column within items group.

To migrate items group use the following command:

rake db:migrate DATABASE_URL=postgres://user:password@host/database GROUP=items

This command applies migrations within items group to database postgres://user:password@host/database

dbmigrator uses sql schema format ActiveRecord::Base.schema_format = :sql. In other words we produce pure sql dumps after db:migrate and use this dump in db:setup task