Pros
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.
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.
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 !!!!
Pros
Easy to install and easy to use. Power house utility.
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
Please Wait
