Hi,
I'm trying to decide which is the best ER diagram software to use and would appreciate any feedback or comparison on the following solutions (or other recommendations)-

Case 2 ($329) http://www.casestudio.com/enu/default.aspx

Datanamic Dezign for Databases 3 ($229) http://www.datanamic.com/

I'm going to use an admin solution like EMS http://ems-hitech.com/mymanager/ to manage the database and users because I can't find any ONE solution that does both database user management and ER diagraming (if you know of one, please let me know).

I have also thought about drawing solutions like Visio and SmartDraw because if I'm going to use EMS I may get into problems using two solutions that both have the abilty to alter table structures (e.g Case 2 and EMS or Datanamic and EMS). If I stuck to EMS for the table structures, relationships, etc and a drawing solution (that can't alter table structures) then I know I am safe. I guess the only thing I would miss out on is reverse engineering (which would be useful).

Any advise on the best way to go would be most welcomed.
Thank you.

I've used both ERWin and ERStudio before, both good products.
========================================
Buh Bye!

Cheers,
Me

Thanks,

But I think both those products are very expensive ($thousands) and I don't think ERWin supports MySQL.

Both support MySQL.
========================================
Buh Bye!

Cheers,
Me

Think I'll go with Visio 2003, it can do pretty well everything ER software can do (including reverse engineering) plus diagraming for a ton of other situations.

Thanks.

Simon.

I use MicroOLAP Database designer for MySQL
http://www.microolap.com/dba/mysql/designer/
(it also supports relations, foreign keys, new MySQL versions)