db_version_manager

== Installation

sudo apt-get install ruby1.9.1-full ruby1.9.1-dev postgresql libpq-dev sudo gem install pg activerecord-pg-adapter sudo gem install db_version_manager

== Configuration

Configure DB settings in config/database.yml, if needed, change config/initializer.rb

== Usage

Available tasks are: rake db:migrate[version] # Migrates DB to specified version (if no argument given, updates to latest migration). rake db:version # Show current DB version. rake help # Help rake migration:applied # Show migrations that are applied. rake migration:generate[description] # Generate new migration. rake migration:unapplied # Show migrations that are not applied. rake migration:version # Show current latest migration version.

== Example scenario

TODO-s:

• If you have Gems bin in your path, you can also just run ./db_version_manager
• Without cloning but with just Gem installation (see first)

=== Obtain db_version-manager

git clone https://github.com/tione/db_version_manager.git cd db_version_manager

=== Configure database

config/database.yml

=== Generate migration template what to edit

rake migration:generate["This is my migration description"]

=== Edit your template in ./app/migrate/date_name.rb

1. For up() define for example "CREATE TABLE .."
2. For down() define for example "DROP TABLE .."

=== Migrate changes to DB

rake db:migrate # if no version given, to last is migrated. you can also downgrade so.