OraFAQ Forum: Server Utilities » Automatically generate E-R diagram

Home » RDBMS Server » Server Utilities » Automatically generate E-R diagram (Oracle 11g)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Automatically generate E-R diagram [message #500047]

Thu, 17 March 2011 06:55

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!

Report message to a moderator

Re: Automatically generate E-R diagram [message #500256 is a reply to message #500047]

Fri, 18 March 2011 11:01

gazzag
Messages: 43
Registered: November 2010
Location: UK

Member

Visio springs to mind.

HTH
-g

Report message to a moderator

Re: Automatically generate E-R diagram [message #500257 is a reply to message #500256]

Fri, 18 March 2011 11:04

BlackSwan
Messages: 20110
Registered: January 2009

Senior Member

http://schemaspy.sourceforge.net/

Report message to a moderator

Re: Automatically generate E-R diagram [message #500464 is a reply to message #500257]

Mon, 21 March 2011 08:41

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?

Report message to a moderator

Re: Automatically generate E-R diagram [message #500465 is a reply to message #500464]

Mon, 21 March 2011 08:49

BlackSwan
Messages: 20110
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

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.

Report message to a moderator

Re: Automatically generate E-R diagram [message #500473 is a reply to message #500472]

Mon, 21 March 2011 10:27

BlackSwan
Messages: 20110
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

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.

Report message to a moderator

Re: Automatically generate E-R diagram [message #500479 is a reply to message #500477]

Mon, 21 March 2011 10:57

BlackSwan
Messages: 20110
Registered: January 2009

Senior Member

http://support.microsoft.com/kb/313565

Report message to a moderator

Re: Automatically generate E-R diagram [message #500480 is a reply to message #500479]

Mon, 21 March 2011 11:00

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.

Report message to a moderator

Re: Automatically generate E-R diagram [message #500481 is a reply to message #500480]

Mon, 21 March 2011 11:02

BlackSwan
Messages: 20110
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

Report message to a moderator

Re: Automatically generate E-R diagram [message #504511 is a reply to message #500481]

Tue, 26 April 2011 03:26

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/

Report message to a moderator

Previous Topic:	Validation steps
Next Topic:	pre-create tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 25 22:37:50 CDT 2013

Total time taken to generate the page: 0.12635 seconds