[Klug-general] database diagraming

[MacGyveR]

On Friday 29 Jan 2010, Mike Evans wrote:
> There are some plugins for eclipse, which I've not tried.
>
> Avoid anything by Rational Software, even though now owned by IBM my
> experience is that they are worse than stuff that I was using 20 years ago.
>
> Although I haven't yet any experience I would have thought that the
> obvious candidate would be MySQL Workbench - it's GPL and it should work
> with everyone's (except Julia's) favourite database :)
>
> It supposedly allows forward and reverse engineering between schema and
> database.  In my personal experience that has always been of limited
> value (ie for prototyping and early development only) but that was
> mostly because DBAs responsible for the sort of large organisation
> databases I've worked with are quite keen to eyeball the DDL and ask
> searching questions about things like cardinality of tables and proposed
> indices.  This is, of course, their job as they get to figure it out
> when performance is crap and it helps if they have some human readable
> stuff to look at as a starter.
>
> Mike
>
> On 29/01/10 13:57, Dan Attwood wrote:
> > Does anyone know of some OSS for creating database diagrams. IE hook it
> > up to a MS sql database and spit out a nice zoomable interactive type
> > map showing the tables and their links?
> >
> > I can do this with Visio but it's a bit rubbish and wondered if any one
> > knew of something better
> >
> > Dan
> >
> >
> >
> > _______________________________________________
> > Kent mailing list
> > Kent at mailman.lug.org.uk
> > https://mailman.lug.org.uk/mailman/listinfo/kent
>
> _______________________________________________
> Kent mailing list
> Kent at mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/kent

I've used a postgresql one for eclipse it worked ok, but i didn't try a lot of 
the features.