ERD on views [message #640519] |
Thu, 30 July 2015 02:08 |
ravikanth_b
Messages: 42 Registered: November 2007 Location: Bay Area, CA
|
Member |
|
|
Hello All,
Is there any ERD which could help create ERD on views? I tried few of them like ER Studio/ERWin/SQL Developer Data Modeler but did not work. They claim to support views in an ERD but relations (auto detect) doesn't show up. I cannot manually add them either.
Most of the Microsoft products expose their systems as views (example config mgr), i wonder how do they document their views?
|
|
|
|
|
|
Re: ERD on views [message #641275 is a reply to message #640691] |
Wed, 12 August 2015 16:28 |
ravikanth_b
Messages: 42 Registered: November 2007 Location: Bay Area, CA
|
Member |
|
|
I tried SQL Developer Data Modeler, 4.1. It would kind of satisfies my need but it is very unstable.
1) keeps crashing
2) Image option for adding a logo image i useless. Cannot hold hi-res pictures. Cannot resize them. Sometimes it just hangs.
3) There is no automatic relationship resolution between views (simple or complex) based on column names.
It is manual work to create the relationships (imagine you have several hundred tables)
It is free, i cannot complain.
|
|
|
|