Displaying 2 results from an estimated 2 matches for "prod_migrate".
2006 Aug 09
1
Different DB connections for migrations vs. running app.
All,
I''ve run into a situation where I want the owner of my DB tables to be
different than the user that accesses them during application runtime.
I believe that I can just set up another DB connection profile (with a
name other than "production") in database.yml and then pass that as
RAILS_ENV to db:migrate instead of "production".
Anyone see any problems with
2006 Sep 06
1
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