Data Modeling Tools

Hi folks... Another "faq" for you all: We're evaluating some data modeling tools, and would really like to hear some input about those that some of you have used or tried. The desired features we would like to see: * It must be Windows-based * It must be able to generate physical schemas for the major DB's (Including Informix!! :-) * Able to modify both logical & physical models (where changes to one must carry over to the other) * Be able to support subtypes * Methodology enforcement * Workgroup support * Reporting capabilities (allowing for customization) * Import/Export facilities Currently we are looking at S-Designor & ERwin 1.5c (demo copies). Both appear to be nice tools, but are lacking in at least a couple of the major features (yes...we're not looking for the Mother-of-all ER tools, just the CLOSEST one to it :-) Moreover, Silverrun appears nice (we have a demo from last year), but I'm not too thrilled with their "modular packaging" approach (ie, separate ERD & reverse engineering packages, which to me equates to more $$$). Anyway, we're leaning towards S-Designor for now. I know this was a hot topic back in June, and if any of you received any feedback then, I would be much obliged if you could share your responses. Any hints (even pointers to other demo copies) would be appreciated! Thanks! May you all have an awesome '95! STEVE ____ ___ ________ ________ /_ _] /_ ]/ ______)/ ______) _/| Steve Morrow, Sr. Programmer/Analyst / _/ / / / (____ / /___ _/ | University of South Florida / _/ / / \\____ ) / _____) _/ | Internet: smorrow@dotrisc.cfr.usf.edu / _/___/ / ______/ / / / _/ | Voice : (813) 974-6889 (_________)(________)(___)______/ |______________________________________