Depending on your needs, MySQL Workbench has a fairly nice facility for doing ER models.<br><br>--Dennis<br><br><br><br><div class="gmail_quote">On Tue, Sep 6, 2011 at 3:05 PM, David Tomaschik <span dir="ltr"><<a href="mailto:david@systemoverlord.com">david@systemoverlord.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">On Tue, Sep 6, 2011 at 2:44 PM, Wolf Halton <<a href="mailto:wolf.halton@gmail.com">wolf.halton@gmail.com</a>> wrote:<br>
> >From Wikipedia:<br>
> <a href="http://en.wikipedia.org/wiki/Entity-relationship_model" target="_blank">http://en.wikipedia.org/wiki/Entity-relationship_model</a><br>
><br>
> ER diagramming tools<br>
><br>
> There are many ER diagramming tools. Some free software ER diagramming tools<br>
> that can interpret and generate ER models and SQL and do database analysis<br>
> are MySQL Workbench (formerly DBDesigner), and Open ModelSphere<br>
> (open-source). A freeware ER tool that can generate database and application<br>
> layer code (webservices) is the RISE Editor. The Open Source Erviz takes a<br>
> simple textual description of the ERD and then uses Graphviz to<br>
> automatically produce a layout. The web application TinyModeler allows you<br>
> to make ER diagrams in a web browser.<br>
><br>
> Some of the proprietary ER diagramming tools are ARIS, Avolution, Aqua Data<br>
> Studio, dbForge Studio for MySQL, DeZign for Databases, ER/Studio, Devgems<br>
> Data Modeler, ERwin, MEGA International, ModelRight, OmniGraffle, Oracle<br>
> Designer, Oracle Data Modeler, PowerDesigner, Rational Rose, Sparx<br>
> Enterprise Architect, SQLyog, System Architect, Toad Data Modeler, SQL<br>
> Maestro, Microsoft Visio, Visible Analyst, and Visual Paradigm.<br>
><br>
> Some free software diagram tools just draw the shapes without having any<br>
> knowledge of what they mean, nor do they generate SQL. These include yEd,<br>
> LucidChart, Gliffy,[13] Kivio, and Dia. DIA diagrams, however, can be<br>
> translated with tedia2sql.<br>
><br>
<br>
</div>I guess I should have explicitly stated that I'd read the Wikipedia<br>
article. There are no fewer than 20 tools mentioned there, including<br>
a half-dozen free software tools. However, I was assuming that the<br>
list there might not be comprehensive, and that the members of the<br>
list might have something subjective to share regarding the quality or<br>
usefulness of the tools, whereas Wikipedia strives to maintain a<br>
purely objective standpoint.<br>
<font color="#888888"><br>
<br>
<br>
--<br>
</font><div class="im">David Tomaschik, RHCE, LPIC-1<br>
System Administrator/Open Source Advocate<br>
OpenPGP: 0x5DEA789B<br>
<a href="http://systemoverlord.com" target="_blank">http://systemoverlord.com</a><br>
<a href="mailto:david@systemoverlord.com">david@systemoverlord.com</a><br>
</div><div><div></div><div class="h5">_______________________________________________<br>
Ale mailing list<br>
<a href="mailto:Ale@ale.org">Ale@ale.org</a><br>
<a href="http://mail.ale.org/mailman/listinfo/ale" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
See JOBS, ANNOUNCE and SCHOOLS lists at<br>
<a href="http://mail.ale.org/mailman/listinfo" target="_blank">http://mail.ale.org/mailman/listinfo</a><br>
</div></div></blockquote></div><br>