I just downloaded a trial version of Navicat MySQL Studio -

http://www.mysqlstudio.com/product.php3

It's a very nice program!!!! (for a novice like me anyway).

They say it gets 11,000 downloads a month and some big name companies like Kodak, FedEx, KPMG Consulting, Ericsson, Siemens AG, Cisco Systems, Ford Motor all use it.

I think it's much better than MySQL Control Center (although it's not free).

With ALL the problems I've been having with Control Center I think I'll switch over.

Has anyone else tried it out? What do you think?

Simon.

Here is another good one -
http://www.webyog.com/sqlyog/

Bob
http://totallyfreeads.com.au

Thanks Bob.

They are both good. I don't know which one to use, I like Navicat's simple layout but I think that Sqlyog may have more features. I also tried MySQL Explorer - http://www.mysqltools.com/mysqlexp.htm which also includes a nice diagram feature. Anyway they all have 30 day trials so I'll play around with them for a few weeks.

If anyone has any feedback on theae products I would be most interested.

Thanks.

Simon.

Why no just use mySQLman.
Fine it dosen't have a fancy gui, but you can do the same with it as you can with anything else.
Its also web based which makes it portable so you can use it on site as well.
I have SQLyog on my xp box and never use it as I find mySQLman to be a lot more flexible. I also use it on site as my main mySQL manager.

Anyway just my 2 cents worth.

Bob
http://totallyfreeads.com.au

I've been using MySQLMan for the past couple of years and it's very good but it doesn't support INNODB tables.

Thanks

Simon.

I found an even better solution - EMS MySQL Manager

http://ems-hitech.com/mymanager/

Looks like it does everything I need (including ER diagrams).

Anyone tried it?

Simon.

I tried EMS MySQL Manager. At first I was excited because of all the features, but it has been very buggy on XP, lots of memory errors.

I'm going with Navicat, although it doesn't have as many features, the design is very intuitive and everything works. I get the feeling this company will add features in the future, and things will work, so I'll invest in them.

Samantha

Hi Samantha,

Thanks for your feedback.

What kind of memory or other errors were you having (e.g system crash, out of memory, etc.) on your XP system with EMS?

How much RAM do you have on your XP system?

Are there any other good or bad points between the two (Navicat and EMS)?

Thanks

Simon.

I have 1GB of memory, and probably was only using about 1/3 or less of it.

I don't have the exact errors messages, but there were several errors about trying to write or access the wrong memory blocks, not about being out of memory. This happened during different use sessions.

The EMS visual query builder is quite buggy. When trying to create the same type of inner joins I had successfully created in Navicat, EMS kept throwing an error about the table not being unique. I had to cut and paste the SQL from Navicat to get it to work. So, EMS isn't writing the SQL code the same, even though I was using the visual editor exactly the same way in both applications.

Additionally, everytime I opened the query, EMS would automatically repeat this last line, squared times that the instance of the line exists. I think this may have to do with my table field being named date, a mysql keyword, but Navicat doesn't have a problem with this.


'date' AS `FIELD_1`,
'date' AS `FIELD_1`,
'date' AS `FIELD_1`,
'date' AS `FIELD_1`,
....

Additionally, I think Navicat has a friendlier report builder, and they have a tutorial for it. Whereas, EMS's help files were not as helpful.

I'm not going to test EMS further because it doesn't do the basics good enough for me. The only thing I liked about it over Navicat was the HTML report that descibes the database. But I can live without it.

Also, I've looked at the other MYSQL admin tools, but you have hand-code more with the others. I like having more choices to interact with my databases via GUI or sql commands. Given all this, I like Navicat the best.

Samantha