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

Question

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

Is is becuase his experince has been so good with Managment 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 managment 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 managment tasks have been in Studio Manager.

Answer 1

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

Answer 2

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

Answer 3

I would suggest Aqua Data Studio. I don't think that it has a free version, however it is pretty powerful and has a ton of great features that are similar to SQL Server Management Studio.

Answer 4

More tools to try: EMS SQL Management Studio or MySQL GUI Tools

Answer 5

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.