List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:April 7 2011 10:36pm
Subject:RE: Any table visualization tools with wires connecting the actual columns?
View as plain text  
I am a paid subscriber to SQLYog -- I love that tool, but AFAIK it doesn't
do diagrams (with wires between tables and all that glory). Am I wrong? Is
that feature there and I just never noticed it?

> -----Original Message-----
> From: mos [mailto:mos99@stripped]
> Sent: Thursday, April 07, 2011 1:36 PM
> To: mysql@stripped
> Subject: Re: Any table visualization tools with wires connecting the
actual
> columns?
> 
> At 02:17 PM 4/7/2011, Daevid Vincent wrote:
> >Does anyone have any suggestions on this? I've written to SQL Maestro
> >twice and they've not replied either.
> 
> Take a look at SqlYog from www.webyog.com. I use their community version
> but their paid version has a schema designer. They are responsive to
emails
> and forum posts.
> 
> Mike
> 
> >
> >
> >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=1
> >
> >   _____
> >
> >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=1

Thread
Any table visualization tools with wires connecting the actual columns?Daevid Vincent2 Apr
  • Any table visualization tools with wires connecting the actual columns?Daevid Vincent7 Apr
    • Re: Any table visualization tools with wires connecting the actual columns?Jason Trebilcock7 Apr
      • RE: Any table visualization tools with wires connecting the actual columns?Daevid Vincent8 Apr
    • Re: Any table visualization tools with wires connecting theactual columns?mos7 Apr
      • RE: Any table visualization tools with wires connecting the actual columns?Daevid Vincent8 Apr
        • RE: Any table visualization tools with wires connecting the actual columns?mos8 Apr
          • RE: Any table visualization tools with wires connecting the actual columns?Daevid Vincent8 Apr
            • Re: Any table visualization tools with wires connecting the actual columns?Johan De Meersman9 Apr
  • Re: Any table visualization tools with wires connecting the actual columns?Martijn Tonies12 Apr