Re: CASE tools for data dictionaries

From: afalout@xtra.co.nz (Andrej Falout) > >In article <37CB3908.E25B2ED6@iol14.com>, wraper@iol14.com says... > > I would suggest strongly that you invest in a copy of ErWin from >Platinum > > Technologies. > >I disagree. I found this tool to be the biggest nightmare piece of >software in my life for the long long time. I really don't know where to >start. I wasn't going to comment, but I'm provoked out of inertia to agree. We had endless grief moving a schema from Oracle to Informix because ErWin would leave little bits out of the schema, at random. > > The product can either read the output from dbschema, > >Only on paper. From 9 out of ten Informix schemas with some level of >complexity, it will fail with choice of error messages ranging from ones >that there support never heard about, to the ones that they have no fix >for other then manually commenting out offending parts of schemaa. I can certainly vouch for this too. > > Once it reads the schema, it will > > generate a very good Entity Relationship Diagram. > >Completely useless jungle of overlayed tables that will take days just to >make visible. And if you intend to infer relationships and/or primary >keys, forget it, it will take days on anything larger then 200 tables, >and it will look hanged, so after you stop rebooting it and it finishes, >you will find on your screen such a nightmare that you will not know >where to begin. Yep. >Unfortunately, I do not have a better solution to offer you. I just want >to tell you that out there, there is one person that regret his decision >to buy this thing, and that this don't happen to him very often. > >At the best, it can be used for prototyping. > > > Best of luck. > >Yes, I agree with this one too. :-) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com