Login or Sign up Help | Site Map
Connecting Tech Pros Worldwide

Which database design tool

Question posted by: none@reply.com (Guest) on June 27th, 2008 07:04 PM
Hi, I am looking for a tool to document and maintain a large data
model (500 tables).
Oracle Designer used to be the tool of choice for this sort of thing.
But given the investment of effort we will be making, and the future
of Designer, it is not the tool of choice for new applications.

Can you recommend an alternative tool?
Our requirements are:

MUST HAVE
- Document tables, indexes, views etc
- generate DDL
- Create diagrams
- consolidate model with database

SHOULD HAVE
- Version control (preferably file-based, se we can use Subversion)
- generate reports (e.g. table listing including descriptions)
- command-line driven generation of DDL scripts (for inclusion in
daily build process)
- generate consolidation scripts (alter table ..)
- multi-user capability (simultaneous edits on different objects)

NOT REQUIRED
- Support for PL/SQL objects. We will maintain these in separate files

Suggestions please?
I'm especially interested whether anyone thinks that jDeveloper fits
this bill.

Thanks,
JD
Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).
 
Not the answer you were looking for? Post your question . . .
184,041 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Latest Articles: Read & Comment
  • Didn't find the answer you were looking for?
    Post Your Question
  • Top Community Contributors