Also check out EMS MySQL Manager. I looked at every MySQL tool I could
get my hands on, and ended up buying a license of this.
Main site is here:
http://sqlmanager.net/products/mysql/manager/
Feature list is here:
http://sqlmanager.net/en/products/mysql/manager/features
It also has access via HTTP tunnelling (I have an older version, so
can't comment on it). It supports 5.0 (stored procedures, views,
triggers), and has a decent visual designer that is able to reverse
engineer a database and generate a diagram.
I have only two complaints: it's a very busy GUI, and it would be be
able to generate a delta of database changes using the GUI (ie reverse
engineer the database into a diagram, make changes, and have a database
patch generated for you).
It's more expensive (at $135 for a business license for Windows, $95 for
Linux) but it's well worth the money.
David
Terence wrote:
It's a bit weak on foreign keys, no support for procedures and views
(if you're looking at MySQL 5) from a gui perspective (from what I
have found). Other plus points are it has a http tunnel feature if you
host your mysql database with someone (requires php on the hosted
server), so you can actually browse the database as though it was
local. There's also a free version if you don't need enterprise
features, so maybe try that out first.
Navicat is an alternative with good support for procs and views.
There's also a 30day trial version.
Scott Hamm wrote:
I'm contemplating buying SQLyog Enterprise for $49 dollars
(non-commerical) for personal use. Do anyone use it and how does it
fare in your opinion?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
