1 安装tiny_tds ,在gemfile ：
source ‘http://ruby.taobao.org‘
gem ‘tiny_tds’
gem ‘activerecord-sqlserver-adapter’, ‘~> 3.2.10’
def os_family
case RUBY_PLATFORM
when /ix/i, /ux/i, /gnu/i,
/sysv/i, /solaris/i,
/sunos/i, /bsd/i
“unix”
when /win/i, /ming/i
“windows”
else
“other”
end
end
if os_family !=’windows’ then
gem ‘therubyracer’
gem ‘thin’
end
使用不同系统时，分别配置不同gem
2 在database.yaml:
test ok 其中如果用了dataserver ，host 和port忽略
development:
adapter: sqlserver
model: dblib
dataserver: 127.0.0.1:1444\sql2012
#host: 127.0.0.1\sql2012
database: test
username: sa
password: xxxxx
#port: 1444
timeout: 5000
encoding: utf8
3 在初始化rb文件里面加入，这样数据库不区分大小写，都以小写为准：
ActiveRecord::ConnectionAdapters::SQLServerAdapter.lowercase_schema_reflection = true