DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Hybrid View

  1. #1
    Join Date
    Feb 2002


    What are the pros & cons of these two products?

    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.

    Any thougths on that would be appreciated. Thanks!

  2. #2
    Join Date
    May 2000
    fremont ca
    yes ERwin can handle large database I reverse engineer 5000 tables in ERWIn within 5 min.
    I prefer ERWIN then designer. Desginer will work with oracle ...
    what about other database ???

  3. #3
    Join Date
    Oct 2000
    I use Designer and I like it, but there are many limitations.

    Among them are:

    1. lack of books available for self training
    2. a huge learning curve

    If a group of developers and admins know the tool well, it can greatly benefit a project.
    David Knight
    OCP DBA 8i, 9i, 10g

  4. #4
    Join Date
    Mar 2002
    Mesa, Arizona
    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


  5. #5
    Join Date
    Feb 2002


    Thanks for your inputs! They are very helpful.

    How do you perform backup & recovery on Erwin?
    In Designer there are import/export utilities. Does Erwin have similar utilities for backup & recovery?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.