From: Martijn Tonies
Date: April 12 2011 7:15am
Subject: Re: Any table visualization tools with wires connecting the actual columns?
List-Archive: http://lists.mysql.com/mysql/224803
Message-Id: <009101cbf8e1$5f388220$1601a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit

Hi,

Also take a look at Database Workbench - www.upscene.com

The free Lite Edition doesn't do diagramming, but the Pro does.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!



> Does anyone have any suggestions on this? I've written to SQL Maestro 
> twice
> and they've not replied either.
>
>
>
> From: Daevid Vincent [mailto:daevid@stripped]
> Sent: Friday, April 01, 2011 4:27 PM
> To: mysql@stripped
> Subject: Any table visualization tools with wires connecting the actual
> columns?
>
>
>
> I am evaluating various tools for diagram generating of existing databases
> on some smaller databases (9 tables or so) first.
>
> The two I've tried so far are these:
>
> http://dev.mysql.com/downloads/workbench/
> http://www.sqlmaestro.com/download/#mysql
>
> Both _seem_ robust and cosmetically polished, but feel to me lacking the
> most obvious and key component of the whole purpose to make an EER 
> diagram.
>
> I don't understand in workbench, why it creates new keys for me on 
> existing
> tables. Maestro doesn't do this nonsense. It isn't the tools business 
> where
> I have keys, it only needs to be concerned with what links to what -- that 
> I
> tell it to. It's further exacerbated by the fact that the documentation
> indicates these aren't even REAL keys, they are cosmetic only! WTF? Why 
> add
> confusion guys?
>
> 1. Neither one seem to be smart enough to automatically know that columns 
> of
> the same name should be linked, and furthermore they should be linked from
> all tables to the one where that column name is the PK. my tables don't 
> have
> true InnoDB FKs setup. And some tables are MYISAM (as they're 
> significantly
> faster). But I do use keys and I do have sane naming conventions, so I 
> don't
> understand why they can't use the names, and if there are multiple tables
> (for some unlikely reason) then just prompt me which table to use.
>
> Which leads me to the second and third problems...
>
> So I manually have started to draw the connections, but:
>
> 2. How can I make the wires stick to a column on the left or right edge, 
> so
> that I can have a direct visual link between the columns. Right now, it
> seems they float around the edge of the table box. That's sort of useless
> isn't it? it's like saying, "well, something in this table points to
> something in that table".?! I would think that two programs with such high
> version numbers would have this feature. Maybe I'm missing a configuration
> or some way I'm supposed to do it?
>
> 3. Some of my databases point to tables in other databases on the same
> server. It would be useful if I could make a wire that indicates this.
>
> Are there other (better) options out there for this? I really don't want 
> to
> do this in Visio or make a printout of the table boxes and tape string to 
> my
> walls to visualize all the databases, tables and columns.
>
> -Daevid.
>
>
>  _____
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1209 / Virus Database: 1500/3544 - Release Date: 04/01/11
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=daevid@stripped
>
>  _____
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1209 / Virus Database: 1500/3544 - Release Date: 04/01/11
>
>  _____
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1209 / Virus Database: 1500/3557 - Release Date: 04/07/11
>
>