Rails - Sep 2006 - Need to override database.yml settings for Capistrano run

All,

Database: SQL Server 2000
SQLServer adapter in ODBC mode

I have a Capistrano deploy script which fails when I run against my 
production DB.

Apparently, this is the because the user that is set up for production 
has "guest" privileges in my SQL Server database and when Capistrano 
runs, instead of looking at the dbo.schema_info table (which has the 
correct version # - yes I know this begs the question how did that 
schema_info table get the correct version #), the user creates it''s own
schema_info table, which of course, gets a default version of 0 and the 
migration attempts to start from there.

I need 1 of 2 things:

1) The ability to override the database.yml user/pass settings for the 
production database

2) A way to specify DB ownership of the schema_info table so that I look 
at the correct schema_info table.

Thanks,
Wes

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

I forgot my current solution to this problem - I created a separate 
connection spec. in database.yml named prod_migrate which has the 
credentials I need to both see the correct schema_info table and create 
objects in the correct database.

Still would be nice to know if I have other options.

wg

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---