List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:April 8 2011 9:12pm
Subject:RE: Any table visualization tools with wires connecting the actual columns?
View as plain text  
It only seems to do the lines for InnoDB tables, not MyISAM... I mean, it
not only won't auto-connect them, it won't even allow ME to connect them. :(

Thanks though.

> -----Original Message-----
> From: mos [mailto:mos99@stripped]
> Sent: Thursday, April 07, 2011 8:50 PM
> To: mysql@stripped
> Subject: RE: Any table visualization tools with wires connecting the
actual
> columns?
> 
> At 05:36 PM 4/7/2011, Daevid Vincent wrote:
> >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?
> 
> David,
>       SqlYog Ultimate has a schema designer. Take a look at the screen
shots.
> http://www.webyog.com/en/screenshots.php
> 
> Mike
> 
> 
> > > -----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
> 
> 
> --
> 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