Erwin Vs Oracle Designer Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Erwin Vs Oracle Designer

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