Problem migrating a rails 4 app to rails 7 running with sqlserver dbms

rubyonrails-talk
1

Hi!

i am currently migrating a rails 4 app to rails 7 running with a sqlserver as dbms. But when i try to run the migrations with rails db:migrate i get the following error:

 TinyTds::Error: There is already an object named 'schema_migrations' in the database.

Which was not a problem before switching to rails7. Running bundle exec rails db:migrate:status results in the error:

Schema migrations table does not exist yet.

Does anyone have a clue how this could be solved?

Entering the rails console and querying models works fine.

2

Hi!

well, the solution was simple once i knew the client uses a different schema for the app. So that was the reason.