Hi I have an unusual one, hoping one of you geniuses can give me a hint
as I don’t know where else to look.
I’m running an combo of Rails/Sql Server (I know, I know, legacy though)
using Ubuntu/UnixODBC/FreeTDS/activerecord-odbc-adapter. The app seems
to be talking to the DB perfectly. When I have a clean database, I’m
able to run rake db:migrate and everything generates correctly. However,
if I add another migration and run the migrations again, I get this
S0001 (2714) [unixODBC][FreeTDS][SQL Server]There is already an object
named ‘schema_migrations’ in the database.
Which, of course there is! I’m just attempting to add a new table,
column, etc. The only way I’ve been able to add migrations thus far is
to wipe the database and rerun the migrations from scratch. Obviously
can’t keep that up forever.
with a --trace argument, I do notice that it thinks I’m running them for
the first time. Where does the rake task look to decide this?
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
Thanks so much for any help you can provide!