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

Thread: Erwin Vs Oracle Designer

  1. #1
    Join Date
    Feb 2002
    Posts
    48

    Lightbulb

    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
    Location
    fremont ca
    Posts
    182
    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
    Location
    Germany
    Posts
    1,185
    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
    Location
    Mesa, Arizona
    Posts
    1,204
    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

    -Ken

  5. #5
    Join Date
    Feb 2002
    Posts
    48

    Arrow

    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