I’m planning to migrate a Drupal 7 site to Ruby on Rails 6. The Drupal site is very media heavy. 100K+ nodes (pages) all with images and videos. There are also many categories and users. One complication is that the Drupal database is MySQL and the Rails dabase will be Postgresql.
I was thinking to create a json feed from the Drupal site and then import and re-create the content in Rails. Am I overthinking this? Should I rather import the content directly from the database?
What are my options for migration? Are there any best practices for such jobs?