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=gcdmg-mysql-2@m.gmane.org

Any table visualization tools with wires connecting the actual columns?

------=_NextPart_000_15F5_01CBF51D.C5892FB0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Does anyone have any suggestions on this? I've written to SQL Maestro twice
and they've not replied either.



From: Daevid Vincent [mailto:daevid@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=daevid@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


------=_NextPart_000_15F5_01CBF51D.C5892FB0--

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

--0015175746fc5f3da904a0593e6c
Content-Type: text/plain; charset=ISO-8859-1

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:daevid@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=daevid@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
>
>

--0015175746fc5f3da904a0593e6c--

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@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=daevid@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=gcdmg-mysql-2@m.gmane.org

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

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@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:daevid@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=daevid@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=daevid@daevid.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

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

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.trebilcock@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:daevid@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=gcdmg-mysql-2@m.gmane.org

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@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:daevid@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=daevid@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=daevid@daevid.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

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

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@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:mos99@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:daevid@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=daevid@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=daevid@daevid.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=daevid@daevid.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

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

--=_07a0c243-8970-481a-876a-24a8b9169aa2
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

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

--=_07a0c243-8970-481a-876a-24a8b9169aa2
Content-Type: application/zip; name=test.mwb
Content-Disposition: attachment; filename=test.mwb
Content-Transfer-Encoding: base64

UEsDBBQAAAAIAK4IiT4DmWVShxIAALnkAAAQAAAAZG9jdW1lbnQubXdiLnht bO1dW3PbOJZ+71+h
0rzM1m4U3i9biad8S8Y7vmRtp6f7yQWCoMw2L2qQjK3+9QOQlERZFAmCsC1H zEPKpM2Dg4Pv3IAD
4NM/nsJg9APhxI+jz2N5Io3/cfDLJxekYDTF6Z0X4xCkn8cK+cXIjWEWoii9 S+cz9Hl8Mb/5//PR
v2P84KAI3o8uYhcF4yoxbSKPD34ZjT79AEGGRsVnsfMHgul4lKQ4g+mHCITk 5eOCyuSkbGQ88t3P
Y0+RTNN0wQdDUdUPsoykDwAqxgdJkoHmWLKkKc6SFLxH8CHJws9j6cmUVdnx bDtvvxsHQTz1IQgm
ZX9KNhxNk1FnNjxNUSTVJMJ7QPPP45J0QbngbMnb3SzFd/Qb4NqOrZBPCm4D PyG8wjhKiVQ+rPdg
8balJyc+mGIQlky4xVMy/riVA0d3PXfJgevTtvJvYZakcXhC4NH4NZIUi5v/ kEpncgHwA8Jls2H+
kLS0qVs1HMezlKBx89PiD0nDfjQt/5Q2Pz749DH/g+WfB3700AScrzi9Kt8X DT5GhO8DFuR++kiJ
lwitNrsJCcOVNBGQuCLq+cNHj99ARMFdcFx9t5TUBg9IQoosgofZ/TypaljO xOJl/i4Z145Wi+I+
p7vQXMf0uhsQBCXDVky45ISFF9eZhPPkz2ByTDSEaN+CB1lRDFXqzIOlAFfV DGOhfCXRFUe1imBr
kF/5lj04j6df/AB9xXE2W1mv5auKQm1jQ9cEsHFD5BGCkoEkfyC2p9p0p3FZ kCuHRXMlz+g8LARS
RMaK8oyNOpWRVckVIIXrOEv9aG0wcOXVs8GotyDAVJE4Vta5YGRAU0UgAv2Z EXVfcJCUj6ws2JIA
FvK3GUYu9YT0ywUzy1/ckpesLCERLM2jOJovXHxSPDEyoKsCGLgFTrAQQ0p/ TjbUo5OmlvSookqm
reimCqmial0UlfxaUm3NqOGkKQ4AP6bX8eM5iqbp/UY8sJWEHy2DpJKF8YHU /vFyJEiAaUFTgIIc
x0EWRgte8oekVgLdPFpJlQ6IrCsQObZRGRDbkWSGqNxSHV221C3sbJUoyNL4 LIIY5ZnBgdwg1uah
hfcAA5gifIPSy7pwr3WUDAd5/RzbMRXIMYlJUwyeg2ZTYRn6FAcBoEFulw7V 0HFLW3b6NAt86Kff
QJ4l9CCIPJAF6a/0993IrMRSpXGWXGZB0KxV9WNmW0az71vj2wvAlHUkVpz6 yWWcFgzKfH0NSovz
gR/fRQqTJfjOd/mYmGEEfZrAd+VjRSIhMThi+bwttSLKcuOHswA9d7P5S+pi xwcwDksLhV0nTMqf
F1ieEK6qWVY3vQoLc8M9GnHgsukkZ47J4hibet/IFqdvUHTFMA0dvpVvkN7S NwDHk6TBN7wn32Aq
lmO/H9+g6T19A/1/8AzEM/wAmGr84B04vANrTvRMYlFEmCQAuileH3CRKbX+ uIu1bqfGbCe32qIA
zP+F5v/Gfoq6JX7A02UkYsruS4yRP40IFwtjtXwhIAGsUqeOHhiGYskQdHf0 ErA8qEnjPtq/OemA
kYcwnQlyi7cHKtRdCF3Ai//6FF3x+iV/7Mn5FlEcsGTfLf3idbcIA8cP/HTe J84iqoJSdJ3RMbq8
Gh0e355dXfKxFIKI2PMYz7n9KqHQ42O6znAVBSziYMB0Fc2CbHhdkGq4jiEO wyu1O+ZCs2EqwNB1
7bXRvOL7ghNEa6DOZoRGH1ALDi6KYM97uMsShO+Ai1GSoKR/rNKJYq8IouIf VRl5AvzjWeSip0VE
Hrk+RALcYkk0nxY1VM9RXK2zR1Ql27E0E4zZHZFDfK8kSCRdfVJH4azNHFMR QY7ZAYMuoDoqbOBr
+3x8zsBiPr/NUovRzEY/mkAUuYycMPiNRnssIl7gKJsQmciw6FVbB9osH69h 9CnC/+XT4eTzQ+S/
oyCGDzf+X6hPVPXop/ffAE6owF7X74iPEHOhFkn8t+uzi8Pr3/n48ZNv2A9B P89ewLsXH1nk/5n1
Gt2l/2Xk4yeZMgjB03X8mHDm9iHCU3QWEZVI+1D4HuVzXnwE/KhHByL0lB4W 09ucFGYAPhTpf/cp
jRnAqU/nRI7jrG1mvS5m8ywBMdu3BRMnyPOj/Kfn7K1+s2Vitkk8JY3TpxmN Z/kHekmpMFucNJLk
McbNroR9cqQa7s4KO0gnb3q60+3sY+C7x/dZVLoyLhEsaSQ9CPQYAhw/fslL nnkUJskcDp2p4aJK
qDcyq8R6SCav6aGz7Sc+7kPiNJrS8rGDi/nZzeEFP50c3Yy8rJslRYBZusX+ dLosT06LJxbzUw1O
btLM6QCRtU/nSYpCzo9vUTiLcR4W8eEzXRC4gfGMa7q8DDSRe5VxawnECKQU koQDRZKJAdM+SPZI
kv9X6uSqHA3JwGIsdmdjLQAJXaCIpvXsKd0FxjjV2F4ZgjD3kN8R5HOqPkti 0W+ljL9Ov70KeJs3
3MoOX50jy4LFT1DnKCNZ1UVMXr18oaOmO5ahmdI+FjpasmvpQzHLuypm0R3N aK4m/7kKHYE7FDru
Q6Fj36X8lyh0ZFm4/FkLHYEGSRcH3/CefAOQNVOR9qfQcSiC359Sx530D46q SZK5l/7BRMB0h9zh
XfkHS3OR+oqF8NIb+weaO5DXCKWDjxh8xNv4CNPUiNp5yn5ullKHHOK95RA2 cKU98xGzOElh7A6b
pgYv8VZewrFMIO9nJqERszWsQrwzL2Hp5r55CTKA88FDDB7ijTwEcqEiO9Je rkVAzQODh3hfc00O
MG1pzzwErQjFg5MYnMRw9sLOnL3gkJHxkP7Shy98ZC2Mk5H7Dja65mVx0JZe YaOrCXVVf4cbXamI
TKk4MXzY6Po6G11ZqjV3eqMri14NG12Hja7DRtefLT4bNrq+042uNICUXGXY 6bqLO137+dNhp+uw
0/Xd7nTN7ZIn5GD/YavrLm91VbqCAnrSa+511d5sryvDEWXDflcR+123va67 asQQYJF+9dFj2Sl6
bdX2W066zGDSKchIbu4K8xxmQewueUSun9zfQZ+FbleTwWYuOgxOfk9dJ8vA bRWkbgJhsAht1iCc
u07nT1utAL8F4Nf+Hprfeg1ZnebXsFH3avMGMAeI2OV9g/APhM8JW8sbnxYv 2i8hc4BjCbrbKCEp
5voFR/RFGwuGCqHes8p1ZapqFs2fT2DXnbFavxpHqSQonTj+VK8d986UXAQt MZTgzNIlMaTuZ4J4
eoh9C4shtXA2wmgpYmgRh2WKoQQS6PtiSGV/+Img7gmjdI8cjB7F0Er9xFAE gR1l8AGLg3smhtTU
UVRZEESnGKEHUUZGVkRZmanzIFCddVFKGFI1FGT/stQTRQkmijA/YRiC8I7m jjC+QgAhEkYKxyGI
xDlWRSBSTYGqKAukZQikJaiPjh8BWv8lxNygOEldYcGWrSrC/M8fs7DGybJl DHblelaGFFRMoZKA
AiWmmrnqTcYl5fId56RMrQD7HZR/Ha/uU4kDxJJg9btLoqGScPGSP8NZ1hsS QzXfckAOB7UkBEEg
jlyIXD8LxdETR4lkhuKIeUEMRNFy44wk4KKIIeiTERVEbVtdKwephipZrsHs 736qrAmlRxU0RU+i
8CGQVKGdAgkGcTQV2VUiOSeIHVEoEUeqkJxAglRyAsnRC3tSP0QCyQkbU2Fc zZEwA0K5SlIQzgTR
IzFsiFJhJmQWi/NVMMM/RI0A+QIVUaVAggJJASyQtyTDHoBI2JAG82kcCcYb 3Z5V7IUQZehIJO+L
hF9OUCQGc4LCgZhTFTvipShFDrvjixoWFGWhKD1BKW+O7DhSr4zre4Lws3wr q7zayLZYNkGs06T7
H+r7TxtaDUwcB7VbICxbcTykbl4Qyr01DcA0AwHT1rSGVLFpqqDYoth9sZe0 Xan3PLg9u/z97PL2
7/J/cS5zH11dne/uuvFLwwmBaEDUCyDq9PByP0Hl+U/I3T1INUxZvAKkTk6P zy4Oz/8uS/8j8aLq
y9lvpyd7iik6EabtHqi2TtC9AqS+nF8d3vJCiX6r7TGWrB00UFsnaF/DPl19 Pzo/7YMmaz/RRKIU
eYif6uMnjdfTkY/lvYWTsntwalq9ewU83ZDI6ZwCyugBKGVvAaXuHqAa129f AVEXpydn3y8opOwe
kFL3FlI7GIq/HZjyqQK5B460vcXRDobh2ws4XgFKR2dfKZoUqQea9jcQR/me 28EwCTNMp19Pr/cT
TbRuYlmws6vx07bCjlcLoI7Or4440XV+dfl19Ovh9dHZ5fYja/YDZLRgbVch tq3q6tUgdnv6221P
iB3/83CPrdiArJdB1n4iKvRdN0D5LvNhTkH4nMLF2cnJ+SkhsZ/girIQYR8O a8fi144vv1+cXp8d
7yeuyPANmBKPKUJjP/G0PEti91C1/Yj4F4cUDbP5S6bo14fHt7s838Baa6r2 rjWt1JgmrNs3mw7P
aRN+ubWy05dNR+7wD5bkOKYHugzWRvMsJ/pfxikoUAtx/Jh4cZxuo7M6CU5C 0ND6nc4zDdPJ8ZKL
DbbWBruufbPHWWCPMX5wUATvJ7P7eeJDEExOfDDFIFxssC2e1quZ261oE11q UD1DMxzDbNyoW2tI
FVWBiqZqTdXVlQPAgjhBWw9O3zy7y1ENi1+Y+elazUPZaAFZJVltgQoTGIZi QQd0PiPfdgByoK3U
nJHfoDBgVmiJ93BHjdFd6/mAa7QwAsE6pd+uPI9IRpqg/5YkXiK/dyfS8aDB bQygyD0W0ZEVnb59
QU8pBseLYerOSOXznl2qUGLsFEM41HBDyPgg1wUZAp6jird1o5jfuEFTihDa DZRyiyRJAU6FCLdK
iQMxlUP4MXi8mQV+46mqrQNTGL8v/jTDaIXo8jk/J941oMFzTjxP07lwFo1L pq0YCgIv2Pi601xE
LgxOjgmLq7H64Se+Q6+fkjnsQuO9G/UesjWHenbORwKx32R3amJjCal9Xe7a 0Hv5gyBXm59YuCBP
fS0Lluqv7HFkDUHojJnHurxY5/RpBiKXRjFyV82uXJ20otLZPpQ3H/Xgg4gg BNj/C534ySwA88bb
01hcQD4s1TMkCyXXTRVyKXk924szujvL7vkthjExBn+zraMvJ4ddRYe6Sr3i Ie7J4N8Tqy5PJJ04
BqWvcT8H82UaGuQ/FybOcq3eJq7CdoA8wrQyUVuY3nLXYAwfuGAegigDwY3/ V36tW3d/nMYzKuou
XFe+fvRdeteUPFGEDNU78kc0h+A6ELunJWcJSX52Sy7toiXvc6fQT2/JDevd WXJjImnv0ZKTMK+X
JTf2zZK3TARxZhi1aqBakq1Lq3+arpmaqeqSZRHRaLJs2bqpy7auyrlDVdmy EcMl3/TNRjaUa+Ni
hTZBnp5ej8pxZ+Pbk73K3d2VEx/jWe0tV4zYu6D/95+N5/bZpSSXE8Yt5qnW W8uurEHyJ8vTGOO0
INvlCoLc7nPcadGWDtfeH+EaxqskxPUHrgieLOkx89NFYk5fiX3FcTYrBTal P7fdhvKCZqnNoTZO
823aBsNRoCXQpiWZc15r1lo8Kgvb272pbSpNAnsTZ8rrSrmm6Fjn0wy19xLW 2jJsgspTvhq9WOXu
0hk9we+oOXrrNdzbPn5qxNi2r+ZcX/0VxyHlc8uHmwvH7CvShb1erUYvHePH bUvyNSggf8qv819x
epOSjNMlTCy8SER+XF+KZrlWkq5tX9OalIX7zX+uL1jZWMSvuQPGkfudkpz7 4wWw84fG5fW8SaOX
INd0KQXTY6Ic0xj7zxxyneukp1lDV9JEVD6sd6nHZT4hSgHJ2lc3K067oaLO EMMMY9LQ4iWXRa6t
jFjdJ9t6Cnrt973DiguAH5aOM8wfmgHn6IptMUbynd1IjxIc0zTdDkH/WtPr DzU5F6HPNE7tSQSY
zSYnMczoSu1Z5MVl8kD4J1x2Tx4cB5iWRLWlnD8jFJdd3Cp9kKX3NGH4v/ge RKMTNLpAZNjzqyfW
BoShxuISPY7yLIz5U+p8iwvj3I3b4vRuVPLb79zWO+f4EqCGS41xXNg/Wko2 ir1Reo9G5UtmIj+I
xPNm5Qk7v+XN7TieIZz6GxMZr6U+dfrSgvlvYIpuUJqSviQrzJsQdq+wMl1o mrZpLq+YrlCuFWG1
UgLgqR8dxWlaREeaZkjVf5auGLqsWIotK7IiKYpKUiRVo0+SrZo0JZKbRmuj qfNyhpHQqP4zNI3Y
fkNVZNm2ya8kUyKvVNMyjFVLUqeWrosc7zWauqXZ0gs0tF6qSUKQaBFizmKc YuCnXQFfQI9oy+2q
MHm2fK6EeY/OJH+f1yMD7Zmz2FbhAgHNovRJp47V+r63V902Hnk5RK7mIRkw crhs8tNHWh5+8Mt/
AFBLAwQUAAAACABiCIk+LXUr8vkBAAAAFAAACwAAAEBkYi9kYXRhLmRi7ZbP b5swFMftkDYSEueo
yuUdk6lUQID8OC2LUmlapqRJurUnYoyjRgqhA5p2u6XS/qD9IbvuP9lthxlK pqTZJqTdFn9k4Nnv
PeOvxQPGF/15zGAWhD6JoY6KCGP0EgAhbu5yzI/CVh+jnCjSDz7ZF1SIpK/4 Ezf+hfV5sVS+vMTr
ICbugtWp5VHqEdU26qaq60xTCTVsVdN0YrpNXTMNN0/MUXfU60x6MOm86vdg midlCtWpM4UVCekN
CU9halpu0zYb2lZSy9X0Z0lZfG29klIhj4NUiNZoGVajTv92xzwxxV0heVL2 hOiWQZnbsnMJ4fGG
ZdgN26L5hD++x6VypYI/H6XCr4bOcDToZpfCzvKzQVBkVYXJzTyCNAVoyEjM PHA/wiBiy3fzKCbj
u+RBNjStmUZ3sxCPn9ugmWe6cZY4QTfbVqutNxS5qsiQspqze2dJfJZ0Jr2r yenGc0tC4jsLPv9z
z8P4og8bdjwemzlp3p4nuI3/4KGB77Nl/JvZhqPXbzuja3jTu4ZfC95a8mao psg1tXBc7lQwmi89
9hB9WPANcchdHKR9J9tMR88MKalxJSlk6RviTSAQ/BdUcekEdbnhkyhmYcQW jMbwAmZh4EP2Ynhy
yWn9f0e8CQSCQ0CWTvBT+ePk+7/3py8QCA4CUf8CweHyE1BLAQIAABQAAAAI AK4IiT4DmWVShxIA
ALnkAAAQAAAAAAAAAAAAAAAAAAAAAABkb2N1bWVudC5td2IueG1sUEsBAgAA FAAAAAgAYgiJPi11
K/L5AQAAABQAAAsAAAAAAAAAAAAAAAAAtRIAAEBkYi9kYXRhLmRiUEsFBgAA AAACAAIAdwAAANcU
AAAiAE15U1FMIFdvcmtiZW5jaCBNb2RlbCBhcmNoaXZlIDEuMAA=


--=_07a0c243-8970-481a-876a-24a8b9169aa2
Content-Type: text/plain; charset=us-ascii


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--=_07a0c243-8970-481a-876a-24a8b9169aa2--

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

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:daevid@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=daevid@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=gcdmg-mysql-2@m.gmane.org