Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle Database showing existing tables and their relationships .

 
Ravi Kiran Va
Ranch Hand
Posts: 2234
Eclipse IDE Firefox Browser Redhat
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ,

Is there a tool around that would produce a diagram showing existing tables and their relationships given a connection to a database ?

I am using Oracle as Database .
 
Ernest Friedman-Hill
author and iconoclast
Marshal
Pie
Posts: 24211
35
Chrome Eclipse IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
TOAD is a huge player in this space. I'm personally fond of DbVisualizer.
 
Ravi Kiran Va
Ranch Hand
Posts: 2234
Eclipse IDE Firefox Browser Redhat
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you very much .
 
chris webster
Bartender
Posts: 2407
32
Linux Oracle Postgres Database Python Scala
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A bit late, I know, but just in case anybody else wants to do this...

TOAD is great, but it's also very expensive.

As an alternative, you could try Oracle's free SQLDeveloper Data Modeler.

This is a pretty good data modelling tool that allows you to import an existing model from a database schema or from other tools e.g. Oracle Designer. You can then view and maintain the model easily via the diagramming tools.

It's easy to install and get started with, costs nothing, and it provides a lot of functionality for data modelling, DDL generation and so on.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic