title: Rails rake db:schema:dump against SQL Server database with multiple schemas
body: <p>The situation I have is that we have multiple schemas on SQL Server that we need to be able to do schema:dump and migrations against.  One schema is for our new Rails application, the other schema is for a legacy system that we have dependencies on.</p>
  
  <p>When running rake db:schema:dump our new schema tables are correctly created in the schema.rb file.  The legacy schema tables do not end up in schema.rb.  I'm wondering how others are dealing with this issue.</p>
  
  <p>Another consideration I have given to this is since our legacy schema tables are fairly static would be to add these to a separate file once and then create a before hook for rake db:schema:load that would run that file prior to the schema.rb.  Is there a before hook for rake db:schema:load; if so what is that?</p>