MS Sql Server

cli.rb

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

# do work here

database.yml

development:
  adapter: sqlserver
  mode: odbc
  dsn: blah-blah-blah
  username: blahblah
  password: blahblah
  encoding: utf8

Gemfile

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

odbc.ini

[blah-blah-blah]
Description = This is the dsn you cite from database.yml
Driver = ms-sql
Servername = WINDOWSNETWORKNAMEOFSERVER
UID = Home
Port = 1433
Database = the_real_db_name