Toad for MySQL 
September 19th, 2007
I recently was told about a great little program called Toad for MySQL by Quest, which basically takes MySQL Administrator and essentially slaps its features silly, then makes your jaw drop with its sheer brilliance. Best of all, it’s free! My favourite feature: data sync and schema sync. You can compare two databases (say a development database and a production database) and do a DIFF on the schema and data, and selectively migrate one to the other, without messing things up. Here’s a screenshot. See the diff in green:

I highly recommend this app for anyone doing MYSQL development.
|
Del.icio.us
This entry was posted on Wednesday, September 19th, 2007 at 7:05 pm and is filed under web development, resources, mysql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

September 20th, 2007 at 4:37 pm
Hi there, I’m one of the lead developers of this product at Quest Software. Thanks for your comments. It’s always nice to hear that people like our work. We also just started the beta program for our version 3.1 of the product which among other features have a new and vastly improved data compare module which allows you to do a bunch of new cool stuff like mapping data between different tables and columns. It also has vastly improved performance when doing queries on large results (It really flies on million or more rows now). For version 4 we are thinking about adding a debugger for MySQL procedures and functions, but as you can imagine since we haven’t nailed down the plans for 4.0 yet. Again, thanks for the praise!
September 22nd, 2007 at 5:18 pm
Sounds great – I’ll definitely check out the beta! Thanks Henrik.