在windows下快速使用rails3和SqlServer2008
win下快速安装http://railsinstaller.org/
含包了以下的组件,也支持连结sql server的gem
Ruby 1.9.3-p125
Rails 3.2
Bundler 1.0.18
Git 1.7.6
Sqlite 3.7.3
TinyTDS 0.4.5
SQL Server Support 3.3.3
DevKit
下载railsinstaller-2.1.0,下一步..下一步..完成。 ruby on rails的环境就优雅的搞定。高兴的是他支持SqlServer,这环境每回安装都会有奇怪的问题。
```bash DOS rails new test_sqld
```ruby Gemfile
#source 'https://rubygems.org'
#上一行注掉改为
source 'http://ruby.taobao.org'
#gem 'sqlite3'
#把 sqlite3改为以下,为了支持SqlServer
gem 'tiny_tds'
gem 'activerecord-sqlserver-adapter', '3.2.1'
连结数据库配置,高级配置查看Using-TinyTDS
```yml database.yml
development:
adapter: sqlserver
#host: localhost
database: myapp_development
username: sa
password: '11111111'
然后
```bash DOS
bundle install
我们建一个model连下SqlServer试一试
```bash Dos rails g model User
```ruby db\migrate\xxxxxxxxxxxxxx_create_users.rb
class CreateUsers < ActiveRecord::Migration
def change
create_table :users, :force => true do |t|
t.column :ten_code, :char, :limit => 10
t.column :ten_code_utf8, :nchar, :limit => 10
t.column :title_utf8, :nvarchar
t.column :body, :varchar_max # Creates varchar(max)
t.column :body_utf8, :ntext
t.column :body2_utf8, :nvarchar_max # Creates nvarchar(max)
t.timestamps
end
end
end
```bash Dos rake db:migrate rails c
User.create(:ten_code=>'test') User.first
参考:
[https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/wiki](https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/wiki)
[http://railsinstaller.org](http://railsinstaller.org)