Optimize developer and administrator productivity in MySQL.
Toad for MySQL empowers MySQL developers and administrators develop code more efficiently. It also provides utilities to compare, extract and search for objects, manage projects, import/export data and administer the database. Toad for MySQL increases developer productivity and offers access to a solid community of experts and peers for interactive support.
It's TOAD, what else to say? It has almost everything you will ever need. It is absolutely the best in its area, by all accounts and all that for $0.00! Its interface is a lot better and more intuitive than TOAD for Oracle. It installs quickly, there's no toolbars, adware, spyware or any such gimmicks - it's 100% free for commercial and private use, there are NO gotchas. Its EULA is easily accessible on their site so you don't have legal problems.
Cons
It has its problems. It can get extremely slow even on a high end PC, it is very resource demanding. Sometimes it hangs indefinitely trying to reconnect. Overall, user interface is definitely not what you can call responsive, it's a resource hog. Obscure errors sometimes pop up on random and reporting them to support is a huge hassle so don't hope that next update will have them fixed. Just like TOAD for Oracle closing the app is a MASSIVE pain (dozens of message boxes, extremely slow) so you'll have to just kill the process manually.
Summary
It's a great product but some parts of it seem poorly implemented, interface design is awesome but what goes on behind it will be your nemesis. It's very feature rich and best of the bunch. As slow as it is, it's still much faster than any online web client you may be using for the same task. Again, the amount of features it has is unparalleled. It is frequently updated and maintained. You may be wondering about tech support but in reality you won't needing it, it's got some issues but it will always DO the job and it always backs up your scripts.
it is all that i was looking for... superb
rickkyrick
Pros
er diagram generator with drag & drop.
pop out result screen for queries which are also auto-hide.
auto-complete with intellisence
SQL command reference with link to IN-BUILT browser
very intutive
FREEEEEEE !!
Cons
could have a better look and feel.
Summary
I've just spent a ridiculously long time looking for an sql gui editor that was free and had the features i was looking for - Basically quite as MS Access. I'm surprised this piece of very well thought of s/w is free. Its well planned, full of features tons of other gui editors which are not free. BIG THANKS to Quest - literally, simplicity at work.
A powerful database admin/development tool - for FREE!
cygnusx1_jag
Pros
An excellent, feature rich tool for developing and maintaining MySQL databases from a company that have been doing this for a while. Familiar environment for users used to TOAD for Oracle or other Quest products. And it is totally free.
Cons
Not as easy to get started with for newbies compared to Navicat for instance, but persavere and the wealth of features will reward you later.
Summary
Quest have a long track record of developing tools for DBAs and database developers - anyone who works with Oracle will probably be familiar with TOAD (it originally stood for Tool for Oracle Application Developers) which has been around for as long as I can remember (I've been using it for 15 years or so!)
Whilst TOAD for MySQL does not have quite the same level of functionality - t's a bit unfair to campare since the target databases are so different and the MySQL version is free (the Oracle version retails at $800 to $2700 depending on whichedition you use!) - it does provide everything you are likely to need on a day-to-day basis, for instance:
- Extremely customisable interface (organise it the way you work)
- Database explorer (brows objects in a tree view)
- Drop/create databases, tables, views, indexes etc
- SQL editor with gui SQL generator
- Procedure/function editor with code formatting ("prettyfier")
- Data Import/Export wizards
- Monitor and kill sessions
- ER diagrammer (reverse engineer a data model from your tables)
- Master-Detail browser (view a parent record in a master table with all linked child records in a detail table - e.g. invoice header + invoice items)
Being a desktop application it is much easier to use than the web based phpMySQLAdmin (I use both - ) and provides many more features for free than commercial desktop applications like Navicat ($80 for a non-commercial licence on Win/Mac).
In short this a commercial strength application, developed by a respected company with a good pedigree, FOR FREE !!!!
This is Great stuff.
twosnjuk
Pros
Easy to install and easy to use. Power house utility.
Cons
Summary
Better have a lunch while installing
crash_beta
Pros
like the interface and functions
Cons
Wayyy too Long to install and search for Installation folders and files, it took 15 min on a pentium4 3.0Ghz machine 512MB ram to install this software, but hey if u have time to wait it's worth it
Summary
Great start, but has some issues
sblaes
Pros
First off, I love Toad for Oracle. And the MySQL tools scene is a bit immature. So, I was excited to hear about Toad for MySQL. I downloaded it and found that it had the same Toad interface I knew. Mostly, it is a good tool, it does what it's supposed to do. Auto-completion works well and the schema tree is a big interface improvement over prior versions of Toad. But...
Cons
I found a few issues with Toad. I was using Toad 1.2. Mostly, these issues were with the basic user interface. For instance, it would often freeze and sometimes would never recover. This was especially troublesome if it was waiting for a database lock to be resolved. I even had to forcibly terminate the application a few times, which caused me to lose a lot of work. The schema comparison report is a great idea, but I found that it's rather hard to read and the interface for generating it is a bit non-intuitive. I did notice that this has changed in the 2.0 beta. I think it's a change for the better. I would love to be able to export an easy to read html report of the differences between two schemas. If the issues get resolved, this product will definitely get at least 4 stars and Quest would get my money (I'll only give a product 5 if it knocks my socks off). For now, I'm probably going to go with Navicat, which is a bit less expensive, or Squirrel SQL, which is free.