If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Can Erwin handle large database? What I mean is the limitation on number of objects such as tables, indexes, constaints, etc.

We are currently using Oracle Designer. Looks like Erwin is more user-friendly... but we are not sure if Erwin is designed to handle large database. Our database grows quite a bit in terms of both data and physical objects.

Both of these products are very capable, we have both. We also have some DBA's that use one, some the other, some both. I think some of the features of Designer have been over-sold and under-delivered. I prefer Erwin over Designer for 4 simple reasons:

Erwin is less expensive
Erwin doesn't require a repository
Erwin is easier to learn and use
Erwin works well with many databases