Re: Entity Relationship Diagramming Tool

[R Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>]

I have used both ERWin and Embarcadero's ERStudio successfully with the 
AS/400, i Series and i5's. However, you should be aware that these 
products (and no product really can, witness the extraction maps of Ops 
Nav...) will only extract the basic definitions and the linking of the 
mapped objects is still a manual thing.

That being said, I did prefer ERWin for it's ability, once the 
relationships were all described, to produce change scripts in the base 
product.

Again, there is no shortcut to producing the models in these products. 
But once the work of migrating the meta-data into these models is 
complete, if you continue to use them, there are significant advantages 
and benefits in the long term aside from just the diagrams.

eftimios pantzopoulos wrote:
> I'm working at a site which has a system that's been in place for over 15 
> years and has had lots of files (but no SQL DDL) added over the years after 
> the base system was installed. No-one knows exactly what is in there and I 
> want to create an ERD using some sort of tool. I know OPs Navigator has a 
> function, but it doesn't seem rich enough in functionality. Does anyone use 
> such a diagramming technique, and if so, any suggestions as to what 
> product(s) might be useful with DB2?
>
> I would presume that the tool could suck basic stuff out of DB2 and then 
> provide drawing tools to relate foreign key relationships at least.
>
> I've been using the Paul Conte/Mike Cravitz book as an SQL reference and I 
> was thinking of the sorts of diagrams that they were using in chapter 20 of 
> the book.
>
> Searching in Midrange didn't provide any definitive answers.
>
>
> Regards,
> Mike Pantzopoulos
>
> _________________________________________________________________
> Advertisement: Your Future Starts Here. Dream it? Then be it! Find it at 
> www.seek.com.au 
> http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fninemsn%2Eseek%2Ecom%2Eau%2F%3Ftracking%3Dsk%3Ahet%3Ask%3Anine%3A0%3Ahot%3Atext&_t=764565661&_r=july07_endtext_future&_m=EXT
>
>