I've made a little lightweight ruby bin executable to handle MS SQL migration (up/down/targetted version) within a CI environment.

Why?

I needed a simple way to manage up/down sql scripts within our CI environment for a bunch of existing, very old MS SQL servers.

If you read my blog enough you'll know that we use a set of ruby scripts in order to facilitate a lot of our build processes, so it made sense to incorporate it into there.

Once you've installed it with 'gem install migsql', you can create up/down migration scripts with the following simple commands:

  • migsql init
  • migsql create-migration some-name
  • migsql migrate
  • migsql migrate to
  • migsql will handle the up/down scripts required to take your database to the desired version.

Where?

As usual, on my github https://github.com/Stono/migsql