Xref: alice comp.databases:36090 comp.databases.ibm-db2:154067466 comp.databases.informix:64175 comp.databases.ms-access:271839 comp.databases.ms-sqlserver:37135 comp.databases.oracle.misc:30173 comp.databases.oracle.server:47788 comp.databases.oracle.tools:24123
Path: alice!news-feed.fnsi.net!netnews.com!howland.erols.net!newsxfer.itd.umich.edu.MISMATCH!cloudbreak.rs.itd.umich.edu!srvr1.engin.umich.edu!news.tc.cornell.edu!news3.cac.psu.edu!usenet
From: Patrick Lanphier <planphier@psu.edu>
Newsgroups: comp.databases,comp.databases.informix,comp.databases.ms-access,comp.databases.oracle.misc,microsoft.public.sqlserver.programming,comp.databases.ms-sqlserver,comp.databases.ibm-db2,comp.databases.oracle.server,comp.databases.oracle.tools
Subject: ER Modeling
Date: Thu, 29 Apr 1999 20:47:49 -0700
Organization: Penn State University, Center for Academic Computing
Lines: 31
Message-ID: <372927E5.D4F6BDF5@psu.edu>
References: <3724A77E.A35CCF2B@psu.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.5 [en] (WinNT; U)
X-Accept-Language: en

I am looking for an ER tool that will provide me with the below
functionality?  Some possibilities are 
System Architect, ERwin, ERstudio, Powerdesigner, Designer 2000 and
Sterling products.

1. Check out an individual objects in the model

2. Bi-Direction Version Control (Database -> Model and Model ->
Database)
3. Table maintenance functionality that will preserve data and alter a
table
4. Revision/Version History

5. Multiple User Access

6. Allow all constraint restrictions (child delete, insert, update;
parent delete, insert, update)

7. A good layout manager and printing capabilities

8. HTML publishing of the model

9. Test Data Generation
10. Table: physical info manipulation (maxextents, minextents, buffer
pool, etc.)
11. Stable
12. With versioning the ability to rollback changes to the database

Patrick Lanphier
Advanced Informational Technologies
The Pennsylvania State University