Connecting to MS SQL with Ruby (platform independent)

database.yml

development:
  adapter: sqlserver
  mode: odbc
  dsn: foo-bar-baz
  username: ********
  password: ********
  encoding: utf8

foo.rb

#!/usr/bin/env ruby
require 'rubygems'
require 'bundler/setup'
Bundler.require(:db)
env = 'development'
ActiveRecord::Base.establish_connection YAML.load_file( File.join(File.dirname(__FILE__),'..','config','database.yml'))[env]
$: << File.join(File.dirname(__FILE__),'..','app','models' )
$: << File.join(File.dirname(__FILE__),'..','lib' )
require 'my_model'

MyModel.where(:some_attr => 'omg')...

Gemfile

source 'http://rubygems.org'

group :db do
  gem 'ruby-odbc', :require => 'odbc'
  gem 'tiny_tds'
  gem 'activerecord-sqlserver-adapter', '~> 3.1.0'
#  gem 'composite_primary_keys', '~> 3.1.0'
end

my_model.rb

class MyModel < ActiveRecord::Base
  set_table_name 'my_legacy_table_name'
  set_primary_key 'OmgIHateWidowsDBAs'
end