title: Cleanest way to change database schema in EF6
body: <p>Currently we are writing a page in mvc5, with an oracle sql database connected with entitiy framework 6. </p>
  
  <p>We currently have two schemas in the oracle database, one for testing and the other for development. The model in entitiy framework is generated from the development database, and works perfectly with it. </p>
  
  <p>The problem comes, when changing the connection string to the testing schema. When the connection string is changed the application is unable to locate the tables (as they still reference the development schemes).</p>
  
  <p>Currently I can fix this, by deleting all the tables from the model, and recreating the model from the correct schema, or manually editing every file referencing the schema. Both solutions are kinda tiresome and error prone. </p>
  
  <p>How is this scenario usually dealt with?</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>It seems that changing the database and retaining the schema, does not produce any error. So this is only schema related.</p>