title: can I use the same schema prefix in two different databases in MS Sql Server. i.e. production/development
body: <p>I am developing rails 4/ Ruby 2 apps. I wanted to have separate production and development databases and app folders. I am using schemas/schema prefixes to make this work. So far, it is pretty much working. </p>
  
  <p>The structure I have for the SQL server is basically the following assuming in= inventory app, pr = production app etc. </p>
  
  <pre><code> - Web  
  
   - - in.tablename1  
   -- in.tablename2
   - - pr.tablename1
  
   - Web_dev
   - - in.tablename1
   - - in.tablename2
   - - pr.tablename1
  </code></pre>
  
  <p>I have separate application folders as</p>
  
  <pre><code>- inetpub\wwwroot\apps\inventory
  - inetpub\wwwroot\apps\production
  
  - inetpub\wwwroot\development\inventory
  - inetpub\wwwroot\development\production
  </code></pre>
  
  <p>I am beginning to think that using the same schema prefix for both the production and development databases might not be a good idea. </p>
  
  <p>Does it matter if I use a schema prefix of in. for both production and development or should I be setting it up something like in. = inventory production and ind. = inventory development. </p>