Connecting Tech Pros Worldwide Help | Site Map

Which database design tool

  #1  
Old June 27th, 2008, 08:04 PM
none@reply.com
Guest
 
Posts: n/a
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
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Any relational database design tool written in Python metaperl answers 2 August 31st, 2006 03:55 PM
Which database design tool none@reply.com answers 0 June 27th, 2006 05:55 PM
Design Tool fantasimus via SQLMonster.com answers 0 February 13th, 2006 11:55 AM
Help With Database Design: Multiple Vendor Data Submitting Marc DVer answers 0 November 23rd, 2005 03:05 AM