Rails app with multiple databases: Primary schema file getting overwritten by secondary schema file

[sandeep-patle1508]

Hi,

We are trying to set up multiple databases with our Rails 6.1.3.2 application. Due to this gem we are facing an issue.

When we are running rails db:migrate

it is overwriting the primary db/schema.rb file with secondary schema file db/marketing_sync_board_schema.rb. After the migration command run both are the same.

They are not causing any database label changes.

Also if we are using database-specific command it is working fine.
rails db:migrate
rails db:migrate:marketing_sync_board

sample database.yml with multi database setup.

default: &default
  adapter: postgresql
  encoding: unicode
  host: localhost
  database: multi_db_test_app_development
  username: admin
  password:
  pool: <%= ENV.fetch('RAILS_MAX_THREADS') { 5 } %>

marketing_sync_board_default: &marketing_sync_board_default
  <<: *default
  host: localhost
  username: admin
  password:
  database: marketing_sync_board_development
  migrations_paths: db/marketing_sync_board_migrate

development:
  primary:
    <<: *default
    database: multi_db_test_app_secondary_development
  marketing_sync_board:
    <<: *marketing_sync_board_default

Please let me know if you need more details here.