Re: entity relationship diagram tool
> > I have a client that is interested in doing entity/relationship diagrams from > an Informix database. They do not want to do case. They do not want to do > re-engineering. They do not want to do application generation. > They want a tool that will, at most, read database definition sql and > generate e/r diagrams. And at the least, a drawing tool that will help with > this process. > If anyone knows of such a tool, I would welcome any information. > Thanks > dougmc@informix.com > Check into Silverrun from Computer Systems Advisers 50 TIce Blvd. Woodcliff Lake, NJ 07675 (201) 391-6500 Fax (201) 391-2210 I've used their products to good effect in the past. They will read the system catalogues and generate ER diagrams from them. They have 4 or 5 modules (I can't find the packet so this is from memory): Interface - they have a different one for different Database products. This is the part which strips the catalogues and preps data for the ER tool - cost $500. (Real basic an SQL script which does SELECT ..... WHERE tabid > 99)_ These modules cost $2,500 each. Entity Relationship Model tool RDM Data Flow Diagram tool (can do Gane Sarson, Yourdon and one or two others I think I would be more verbose - I have an eval copy here, but my need for it went away before I ever got a chance to do more than play with the current version - so I'm a little unclear on how everything works. They do have a common dictionary to all modules. This copy runs under Windows, the one I've used historically ran under MacOS. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, BSMC Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ "A thing is bigger for being shared" - Gaelic _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________