Skip navigation links

MySQL Forums :: MySQL Workbench :: Tool to create ER Diagram automatically?


Advanced Search

Re: Tool to create ER Diagram automatically?
Posted by: Roland Bouman ()
Date: July 01, 2007 01:59AM

Hi Peter Pan,

"Now next question, if I have a schema which is not implemented in InnoDB (I guess its in MyISAM)"

have you checked? Maybe it uses innodb and the foreign keys just aren't defined.

"is there any way by just changing the engine type, and with some tool, it would deploy those constraints, and then I could view the conceptual model?"

Well, you would still be looking at a *data model* but yeah I see what you mean. All I can say is: yes, this is possible, but if all you want is a diagram, why not simply reverse engineer the model as is, and just add foreign keys in your model.

"One of my point here is, if we are saying Workbench is an ER tool,"

As I said before: I would not call it an ER tool, rather a data model diagramming tool.

"Isn't there any simpler way? may be dumping all the queries extracted from the code, to give at least a crude ER diagram which one can refine."

Well, that is somethin workbench cannot do for you. I can only reverse engineer schemas - it does not infer relationships based on queries

Options: ReplyQuote


Subject Written By Posted
Tool to create ER Diagram automatically? jake miller 11/09/2005 02:05PM
Re: Tool to create ER Diagram automatically? Roland Bouman 11/11/2005 06:46PM
Re: Tool to create ER Diagram automatically? rach a 04/04/2007 01:54AM
Re: Tool to create ER Diagram automatically? Roland Bouman 04/04/2007 02:03AM
Re: Tool to create ER Diagram automatically? rach a 04/04/2007 02:32AM
Re: Tool to create ER Diagram automatically? Roland Bouman 04/04/2007 02:43AM
Re: Tool to create ER Diagram automatically? rach a 04/04/2007 05:40AM
Re: Tool to create ER Diagram automatically? Roland Bouman 04/04/2007 06:27AM
Re: Tool to create ER Diagram automatically? Peter Pan 06/27/2007 01:50AM
Re: Tool to create ER Diagram automatically? Roland Bouman 06/27/2007 06:05AM
Re: Tool to create ER Diagram automatically? Peter Pan 06/30/2007 11:50PM
Re: Tool to create ER Diagram automatically? Roland Bouman 07/01/2007 01:59AM
Re: Tool to create ER Diagram automatically? lida m 12/24/2007 01:38AM
Re: Tool to create ER Diagram automatically? Roland Bouman 12/24/2007 02:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.