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:mo...@fastmail.fm] > Sent: Thursday, April 07, 2011 8:50 PM > To: mysql@lists.mysql.com > 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:mo...@fastmail.fm] > > > Sent: Thursday, April 07, 2011 1:36 PM > > > To: mysql@lists.mysql.com > > > 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: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=dae...@daevid.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=dae...@daevid.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
