Looking for a Tool to Compare MySQL Databases and Generate Update Scripts

Honestly, I'm not aware of specific tools that do exactly what you need. It would be wise to prevent this issue by using tools for automating database migrations. Look into something like Flyway if your tech stack doesn't have built-in solutions. After your initial comparison and updates, setting up automated migrations could save you a lot of hassle later.

Redgate offers a database comparison software that I've personally used to upgrade databases. Just a heads up, it's best to test with a backup first before making any changes.

There are quite a few schema management tools available, but I'm not sure if any can do direct comparisons like what you're looking for. Typically, it's advised not to change databases directly. Instead, use something like Entity Framework Core Migrations to help manage your database changes; might be worth checking out.

I guess my approach hasn't been the best. Can anyone guide me on the correct way to manage database changes? Any videos or tutorials on best practices would really help me out.

Just curious, why do you have a different database structure between your dev and prod? It's generally expected that production environments hold sensitive data, and having a development environment that's newer can lead to inconsistencies. Typically, there should be another stage that mirrors production for testing.