Trouble Running Migrations in Production with v2

[snow saffron]

Can someone explain how to run migrations in production in v2?

In local dev, it has magic where it will create the tables for me. However, when trying to run payload migrate, it's not adding all the tables for all my collections like I would expect in local dev.

[velvet swallow]

Original message from @warm sky - Moved from #general message