Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
oberon555
Starting Member
2 Posts |
 Posted - 2009-04-26 : 16:14:27
|
| 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. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-04-26 : 16:46:12
|
| I can't find the demo of it, but this looked pretty neat:http://code.google.com/p/wwwsqldesigner/Not sure if it's exactly what you need but it's a start.You might be better off posting on the Rails or Oracle forum, SQL Team specializes in MS SQL Server. |
 |
|
|
oberon555
Starting Member
2 Posts |
Posted - 2009-04-28 : 06:44:53
|
| Thank you, robvolk!Looks similar to what I am looking for. |
|
|
|
|
|
|
|
|
Tool for online viewing of DB relational model