Tool for online viewing of DB relational model

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » Tool for online viewing of DB relational...

Tool for online viewing of DB relational model

Rate Topic

Display Mode

Topic Options

Author

Message

oberon555

Posted Sunday, April 26, 2009 2:24 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 30, 2009 11:34 AM
Points: 1, Visits: 2

Hello guys,

Can you please advise me what tool to use for my task?
I am working in offshore software development company (around 20 developers). We are developing online financial system working with Oracle DB. Primary development is done with Ruby/Ruby on Rails and database structure is created/updated with Ruby migrations (well, I'd say those are scripts to create/update DB structure, the scripts are implemented with Ruby). DB structure is pretty complex including around 150 tables.
Anyway, what I need is to see overall DB structure (DB relational model) as a graph. I can use some modeling tool, like Embarcadero ER Studio or Oracle Designer, to reverse engineer database and view it as a graph. But, then, either other developers who want to see up-to-date DB graph will have to do the same or we need to share this graph somehow (which will raise a question who is in charge of regularly updating the graph). That is not convenient. So, I wonder, possibly there is a an online tool which we can install on our internal Web server showing DB structure as a graph (of course automatically updating it when DB structure changes). We also would like to have online DB related collaboration tools too, but this feature is a MUST.

Best regards.
Konstantin.

Post #704648

Atif-ullah Sheikh

Posted Thursday, April 30, 2009 4:04 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, March 14, 2013 4:15 AM
Points: 3,240, Visits: 4,960

You can Use APEX DB Documenter to generate the HTML of the database. Then host the HTMLs on any central location.

This would possibly solve your problem.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.

You can check my BLOG here

Post #707517

« Prev Topic | Next Topic »

Permissions