A powerful management tool for MySQL with similar features to SQL Server Management studio [closed]

Question

I am currently working with a developer who is experienced at Ms-SQL, but not much at MySQL. He has been cursing MySQL for having Bugs, and also being far harder to use.

Is is because his experience has been so good with Management studio. It seems to me that his problems are with using phpMyAdmin.

For example, he cites not being able to cross join and compare between tables of different structures using MySQL. Is the problem actually our choice of management tool, or does MySQL have these flaws that my developer thinks. I hope not, as I have just been blown away how fast doing various data management tasks have been in Studio Manager.

Answer 1

You should really check SQLYog. It's great, and has a community version.

Answer 2

Hate to rain on your parade of tools, but while some of the ones mentioned here are pretty cool, none of them have the mojo of SSMS.

In my MySQL work, I basically switched between SQLYog and MySQL GUI Tools, depending on what I did. SQLYog Enterprise Edition (e.g. the non-free one) also adds support for really basic schema code completion.

Answer 3

Quest Toad is good and has pay and free versions for *MySQL.

• free version no longer available