Re: Any table visualization tools with wires connecting the actual columns?

2011-04-12 Thread Martijn Tonies

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



Re: Any table visualization tools with wires connecting the actual columns?

2011-04-08 Thread Johan De Meersman
- Original Message -
> From: "Daevid Vincent" 
> 
> 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. :(

Probably because it wants to adhere to the engine capabilities, and MyISAM 
doesn't have referential integrity.

MySQL Workbench seems to do it right, though. It may or may not complain at 
apply time, but it does seem to save the relations you set, even for MyISAM 
tables. See attached file as example :-)

The tool is freely downloadable from the MySQL site.


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel


test.mwb
Description: Zip archive

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: Any table visualization tools with wires connecting the actual columns?

2011-04-08 Thread Daevid Vincent
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 

RE: Any table visualization tools with wires connecting the actual columns?

2011-04-07 Thread mos

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=arch...@jab.org



RE: Any table visualization tools with wires connecting the actual columns?

2011-04-07 Thread Daevid Vincent
Whoa! I never realized Toad did that. Man that is one robust program. I'm
half minded to switch away from 'the Yog'... especially for FREE! Yeah, and
it does do the sticky wires!! It only guessed some of them, but at least
it's something. It seems to be missing an "auto arrange" kind of feature so
once I make the wires, it can optimize the layout, but compared to other
other crappy options, this is way better... and did I mention it's FREE!
zOMGz.

d

> -Original Message-
> From: Jason Trebilcock [mailto:jason.trebilc...@gmail.com]
> Sent: Thursday, April 07, 2011 12:38 PM
> To: mysql@lists.mysql.com
> Subject: Re: Any table visualization tools with wires connecting the
actual
> columns?
> 
> Toad for MySQL can do the diagramming piece...but, it looks and feels like
> you might have some of the same frustrations with it as well.  But,
another
> tool worth exploring nonetheless.
> 
> On Thu, Apr 7, 2011 at 2:17 PM, Daevid Vincent 
> wrote:
> 
> > 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.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



RE: Any table visualization tools with wires connecting the actual columns?

2011-04-07 Thread Daevid Vincent
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: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=arch...@jab.org



Re: Any table visualization tools with wires connecting the actual columns?

2011-04-07 Thread mos

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=arch...@jab.org



Re: Any table visualization tools with wires connecting the actual columns?

2011-04-07 Thread Jason Trebilcock
Toad for MySQL can do the diagramming piece...but, it looks and feels like
you might have some of the same frustrations with it as well.  But, another
tool worth exploring nonetheless.

On Thu, Apr 7, 2011 at 2:17 PM, Daevid Vincent  wrote:

> 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
>
>