how to create a database diagram

I'm looking for a tool (preferably open source) which would allow me to
create an ER diagram from an existing database. My database is hosted so I
don't have EM.
Thanks for any suggestions.Most decent tools will have the ability to reverse engineer the diagrams.
If you have MSDN, then Visio (Enterprise Edition) will do it and then
there's Erwin of course (some cheaper ones here:
http://www.freedownloadmanager.org/downloads/entity_relationship_diagrams_software/).
Don't know of any decent free tools for this though.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Hi Paul
Thanks for the info. These solutions are a little out of my price range...
for the price of Erwin I could hire a graphic design artist to draw my model
;) I found a free plugin to WebMatrix at CarlosAG.net called DbDiagrams that
will suffice. A little roundabout, since I don't normally use WebMatrix but
it should do the trick.
Thanks again!
"Paul Ibison" wrote:
> Most decent tools will have the ability to reverse engineer the diagrams.
> If you have MSDN, then Visio (Enterprise Edition) will do it and then
> there's Erwin of course (some cheaper ones here:
> http://www.freedownloadmanager.org/downloads/entity_relationship_diagrams_software/).
> Don't know of any decent free tools for this though.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
>