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:dae...@daevid.com]
Sent: Friday, April 01, 2011 4:27 PM
To: mysql@lists.mysql.com
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=dae...@daevid.com
_
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
