i donot know where exactly to post this question, in this dba forum , or development forum
i wanted to know that whether any one has used ERWIN Data modeler for creating and maintaining oracle database. ?
how is this tool ? Is it like statspack, DBAartisan tool or different
I have used Erwin, it is fine but does not have all the Oracle modeling constraints (that Designer has).... the good point is that Erwin is compatible with almost all databases.
DBArtisian and ER-Win are designed to work with independent of RDBMS. There are certain limitations in these two tools. They will not consider full features of Oracle 8i/9i.
Where as Designer needs back end Oracle Server. Designer is slower than the other two.
We use ERwin here.
It gets the job done for modeling purposes.
I have also used it to forward and reverse engineer databases. It came in handy when I had to extract a FOXPRO database (Ugh!) design/table-structure.
Mainly we use it for modeling and then we write scripts for building the databases.
It is pretty easy to learn and use if you even have slight knowledge of data-modeling.
Click Here to Expand Forum to Full Width