good db diagramming tool?

Looking for a recommendation on a good db diagramming tool.
TIAenterprize manager makes diagrams... and shows relationships and stuff
straight from the database
visio is nice for planning, does not create diagrams out of sql,
expensive)
dia is free (uml tool) but more for code planning than db planning|||Visio (for Enterprose Architects) does generate diagrams just reverse
engineer the DB
Also take a look at ERWin (Allfusion)
http://sqlservercode.blogspot.com/|||The problem with SQL Server's Diagram tool (at least the 2000 version) is
that it doesn't support adding Views to the diagram.
<vortep@.gmail.com> wrote in message
news:1137002649.327842.256130@.g43g2000cwa.googlegroups.com...
> enterprize manager makes diagrams... and shows relationships and stuff
> straight from the database
> Visio is nice for planning, does not create diagrams out of sql,
> expensive)
> dia is free (uml tool) but more for code planning than db planning
>|||I am not completely sold on Enterprise Architect (
http://sparxsystems.com.au/products/ea.html ) -- I find the result very hard
to work with / customize, and in general, it looks like crayon scribblings.
Maybe it's only because I've tried using it on large and complex schemas,
and it's been a while -- so maybe their recent builds are better. On the
other hand, we have a couple of people here who have loved it fo as long as
I've known it existed.
Personally, I have not found a diagramming tool that I am satisfied with.
Enterprise Manager is horrible IMHO, and when others here use it (and put
all those stupid objects in there), it usually results in a rap on the
knuckles with my ruler.
"Dr Van Nostrand" <nobody@.nowhere.com> wrote in message
news:%23rtzIftFGHA.344@.TK2MSFTNGP11.phx.gbl...
> Looking for a recommendation on a good db diagramming tool.
> TIA
>|||I have been pretty happy with ERwin for years, though they seem to get just
a bit worse with every version, in some small sniggle of a way.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"SQL" <denis.gobo@.gmail.com> wrote in message
news:1137002837.078559.302760@.g14g2000cwa.googlegroups.com...
> Visio (for Enterprose Architects) does generate diagrams just reverse
> engineer the DB
> Also take a look at ERWin (Allfusion)
>
> http://sqlservercode.blogspot.com/
>