470,816 Members | 1,200 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,816 developers. It's quick & easy.

Which database design tool

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
Jun 27 '06 #1
0 2575

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by none | last post: by
reply views Thread by Jack | last post: by
reply views Thread by Winder | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.