Tool for online viewing of DB relational model

  • 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.

  • 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
    [font="Arial Black"]here[/font][/url][/right]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply