如何在Windows的Rails 4中将我的Rails应用程序从Mysql切换到Sql Server [英] How may i Switch my Rails App from Mysql to Sql Server in rails 4 in Windows

问题描述

如何在Rails 4中将数据库从MYSQL更改为Sql服务器

How may i change my database from MYSQL to Sql server in Rails 4

 What configuration i may specify in database.yml file and what all gem i may need to add for that.Please help. :)

推荐答案

将此添加到gemfile

gem install mysql2

然后发送到database.yml

default: &default
  adapter: mysql2
  encoding: utf8
  host: 127.0.0.1
  port: 3306

development:
  <<: *default
  database: development_db_name
  username: YOUR_USER_NAME
  password: YOUR_PASSWORD 

test:
  <<: *default
  database: test_db_name
  username: YOUR_USER_NAME
  password: YOUR_PASSWORD

production:
  <<: *default
  database: production_db_name
  username: YOUR_USER_NAME
  password: YOUR_PASSWORD

这篇关于如何在Windows的Rails 4中将我的Rails应用程序从Mysql切换到Sql Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！