error when setting a schema

[Christopher Mendla]

I need to have the data tables for each app under their own schemas. 

I set up the connection as 

production:
   adapter: sqlserver
   host: cprosql
   port: 1435
   database: cctweb
   username: researchlibrary
   password: xxxxxx
   schema_search_path: rl_

i dumped the schema and then loaded the schema. 

The tables came up as dbo.tablename. I manually changed them to a schema of rl_.  When I ran my app, I got the following error message. I'd appreciate any thoughs. 

TinyTds::Error: Invalid object name 'schema_migrations'.: EXEC sp_executesql N'SELECT [schema_migrations].* FROM [schema_migrations]'

Rails.root: C:/inetpub/wwwroot/apps/research_library

Application Trace | Framework Trace | Full Trace