I fully agree that ERWIN is not an all in all tool.
Also this is not a product review.
I am just showing how to build a Data Model, specifically
focussing on 'Forward Engineering'
I do build and maintain schemas upside of 200 tables. I use
a feature called 'Subject Areas' to handle such large models.
I should admit that I have never worked with a model comprising
In my opinion no tool can help us in 'Reverse Engineering' the way
the human mind wants it to be. (atleast as of where the technologies
stand today.) Here again I could wrong like ever.
I have used ER Studio and ERWIN, and neither of these tools help me
in reverse engineering a database. I first reverse engineer, and manually spend
hours, organizing the diagram, before I can start working on it.
The other two CASE tools I am aware of are Rational Rose and Oracle Case.
They may be a bit better, but I am sure there is no way they can draw the
diagram the way I wish it to be, when I reverse engineer a database.
In my opinion ERWIN as a Data Modeling tool definitely helps for Forward Engineering
a reasonably sized database.
Complete Compare as well as Macros are not so good in my opinion too.
For Comaring Database Schemas I liked Embarcadero better than any other tool,
but to compare a DB Model with a Schema, I am yet to find one.
If I am commenting something wrong, please correct me.
I know there are Gurus around.