How to compare/update two mySQL databases' schema

Okay, I've got two databases, the second one being a开发者_Python百科 more up to date version of the first one. It has new columns, tables, constraints, and whatnot.

I was wondering if there is a solid program out there that will update the first database with all that of the second already updated database (Not the data, just the tables, columns and all that) or am I stuck creating my own update script from scratch?

---

I actually found another post, that did not look like the same thing but it still helped me anyway, I found a program called Toad for MySQL and it has a compare Schema option that compares the two databases and then can sync one to the other (it creates a script and executes it) it seems to be working flawlessly, but I'm still testing the web app that uses the database to ensure this is true.

---

If you're on Windows, the RedGate SQL data and schema compare tools are beautiful:

http://mysql-compare.com/info

I've used them a few times. They're quite simple to use.

They're designed around creating DB diffs for moving from dev/QA/staging environments to integration/production environments (so yes, they generate scripts).

---

If you are looking for a tool that will compare at the schema level then I would suggest Navicat. The older version that I use works well for getting my production and development boxes in synch. I don't recommend it for large levels of data synchronization though - it seems very slow compared to a SQL dump and SQL import.