Set up schemas for MS SQL Server

I need to run a number of rails apps with their tables in one SQL database.

I noticed that under Data Sources and Drivers for MS Sql, there is a tab called Schemas & Tables - In there, there are a number of schemas.

Am I correct in assuming that I can:

  1. create a schema in the sql manager
  2. Click the boxes for that schema instead of whatever is selected as default

and that will point the project to those schemas??



1 comment
Comment actions Permalink

Hello, Christopher,

sorry for the delay. You can work with those schemas, but it won't change the configuration of your RoR project, because database configuration is set in database.yml file.


Please sign in to leave a comment.