RikMigrations

RikMigrations is a database migration library for .NET based on the migrations facility provided by Ruby on Rails. It allows simple upgrading and downgrading of databases using .NET code (such as VB or C#) either from the command line or built into your application. Unlike many other migration frameworks, RikMigrations is a stand-alone library which does not rely on a large surrounding framework.

You can download RikMigrations from CodePlex.

Features

  • Create/drop tables and columns
    • Set columns as primary keys, foreign keys, unique constraints, not-null, default values, identity
  • Group migrations into modules which are versioned independantly
  • Run migrations from command line
  • Run migrations from code
  • Auto generate migrations from existing database (see blog post for details)

Limitations

  • Only supports MS SQL databases.
  • Only supports tables - no views, stored procedures, etc...

Documentation

RikMigrations documentation is currently being developed. 

A basic tutorial on RikMigrations is available here.
Some directions on subsequent migrations is here.
Information on specifying types is available here.
More advanced topics are discussed here including Primary Keys & Foreign Keys.

About Us

RikWare is a software development company based in Brisbane, Australia. Led by director, Richard Mason, RikWare focusses on solving challenging business problems promptly and effectively.

RikWare is also the owner of Aussie Bushwalking, a free, wiki-like collaboration site for bushwalkers and the creator of RikMigrations, a migration framework for .NET.

Aussie Bushwalking

Want to discover some new bushwalking ideas? Share a few of your own? Aussie Bushwalking is like Wikipedia... but for bushwalkers. Head on over. Anybody can see the walks and it's free to sign up and share your own.

 

RikMigrations

RikMigrations is a database migration library for .NET based on the migrations facility provided by Ruby on Rails. It allows simple upgrading and downgrading of databases using .NET code (such as VB or C#) either from the command line or built into your application. Unlike many other migration frameworks, RikMigrations is a stand-alone library which does not rely on a large surrounding framework.