[Klug-general] database diagraming

[nathan.friend at gmail.com]

Dia is good for flow diagrams.  May have a db add on.
Sent from my BlackBerry® wireless device

-----Original Message-----
From: Mike Evans <mike at tandem.f9.co.uk>
Date: Fri, 29 Jan 2010 15:50:21 
To: Kent Linux User Group - General Topics<kent at mailman.lug.org.uk>
Subject: Re: [Klug-general] database diagraming

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