Home » RDBMS Server » Server Utilities » Automatically generate E-R diagram (Oracle 11g)
Automatically generate E-R diagram [message #500047] Thu, 17 March 2011 06:55 Go to next message
lucienlazar
Messages: 62
Registered: November 2010
Location: Romania
Member
Hi guys,

I would like to generate automatically at a certain interval a E-R diagram with all the tables in a schema and put the file on a certain location. My problem is the word AUTOMATICALLY. Toad Data Modeller does everything I want except this.

Can you suggest me a tool that might do that? It doesn't have to be free.

Thanks!
Re: Automatically generate E-R diagram [message #500256 is a reply to message #500047] Fri, 18 March 2011 11:01 Go to previous messageGo to next message
gazzag
Messages: 267
Registered: November 2010
Location: Bristol, UK
Senior Member
Visio springs to mind.

HTH
-g
Re: Automatically generate E-R diagram [message #500257 is a reply to message #500256] Fri, 18 March 2011 11:04 Go to previous messageGo to next message
BlackSwan
Messages: 21944
Registered: January 2009
Senior Member
http://schemaspy.sourceforge.net/
Re: Automatically generate E-R diagram [message #500464 is a reply to message #500257] Mon, 21 March 2011 08:41 Go to previous messageGo to next message
lucienlazar
Messages: 62
Registered: November 2010
Location: Romania
Member
Tried it but has no option to generate the diagram automatically every week let's say and this is what I want.

Any other suggestions please?
Re: Automatically generate E-R diagram [message #500465 is a reply to message #500464] Mon, 21 March 2011 08:49 Go to previous messageGo to next message
BlackSwan
Messages: 21944
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

use DBMS_SCHEDULOER

[Updated on: Mon, 21 March 2011 08:49]

Report message to a moderator

Re: Automatically generate E-R diagram [message #500472 is a reply to message #500465] Mon, 21 March 2011 10:19 Go to previous messageGo to next message
lucienlazar
Messages: 62
Registered: November 2010
Location: Romania
Member
BlackSwan wrote on Mon, 21 March 2011 08:49
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

What did I miss?

Quote:
use DBMS_SCHEDULOER

Could you please be more specific? I need a diagram with the tables and the relations between them.
Re: Automatically generate E-R diagram [message #500473 is a reply to message #500472] Mon, 21 March 2011 10:27 Go to previous messageGo to next message
BlackSwan
Messages: 21944
Registered: January 2009
Senior Member
>What did I miss?
providing OS name & version to start the list.

what part of the documentation do you NOT understand?

[Updated on: Mon, 21 March 2011 10:29]

Report message to a moderator

Re: Automatically generate E-R diagram [message #500477 is a reply to message #500473] Mon, 21 March 2011 10:45 Go to previous messageGo to next message
lucienlazar
Messages: 62
Registered: November 2010
Location: Romania
Member
Oracle 11g Standard Edition on Windows Server 2008.

I don't think it's related in any way to Oracle documentation. I need an external tool capable of creating a schedule for an E-R diagram. Hope my problem is clear.
Re: Automatically generate E-R diagram [message #500479 is a reply to message #500477] Mon, 21 March 2011 10:57 Go to previous messageGo to next message
BlackSwan
Messages: 21944
Registered: January 2009
Senior Member
http://support.microsoft.com/kb/313565
Re: Automatically generate E-R diagram [message #500480 is a reply to message #500479] Mon, 21 March 2011 11:00 Go to previous messageGo to next message
lucienlazar
Messages: 62
Registered: November 2010
Location: Romania
Member
I know how to schedule a task in Windows. Please provide me a solution for creating a scheduled task that would update an E-R diagram of all tables in a Oracle schema. If you can find any. Thanks.
Re: Automatically generate E-R diagram [message #500481 is a reply to message #500480] Mon, 21 March 2011 11:02 Go to previous messageGo to next message
BlackSwan
Messages: 21944
Registered: January 2009
Senior Member
>Tried it but has no option to generate the diagram automatically every week let's say and this is what I want.
so combine AT & schemaspy
Re: Automatically generate E-R diagram [message #504511 is a reply to message #500481] Tue, 26 April 2011 03:26 Go to previous message
lucienlazar
Messages: 62
Registered: November 2010
Location: Romania
Member
Thank you Blackswan, SchemaSpy worked just fine for what I wanted.

I wrote a blog post about how to generate and update E-R diagrams automatically, feel free to download the batch file and use it:
http://www.lucianlazar.com/oracle/generate-e-r-diagrams-automatically/
Previous Topic: Validation steps
Next Topic: pre-create tables
Goto Forum:
  


Current Time: Fri Apr 18 18:01:13 CDT 2014

Total time taken to generate the page: 0.25065 seconds