What are some tools to compare MySQL databases and generate scripts for differences?

Quick question: are you trying to compare the actual data inside the databases or just their structure? That can change the tools you’d want to look at.

If you're looking for a more automated solution, consider using tools like Flyway for database migrations. That way, you can avoid situations where you're manually comparing databases. It might save you some work in the long run.

I'm kind of new to this too, so I get your struggle! Having different structures between dev and prod isn’t ideal, especially if you’re making updates. You might want to look for tutorials on proper database migration strategies. There are definitely better practices out there that can help you manage schema changes!

There are plenty of schema management tools out there, but I'm not sure many allow for direct comparisons as you're looking for. Typically, it’s advised to manage changes via tools rather than modifying the database directly. I've used Entity Framework Core Migrations in my work, and it's pretty effective.

You might want to check out Redgate's database compare software. I've used it to upgrade a database, and it works well. Just remember to test it on a backup before making any changes to your live data.