Erwin & other DataModeling Tools
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Erwin & other DataModeling Tools

  1. #1
    Join Date
    Aug 2000
    Posts
    143
    Can anyone recommend a reliable data modeling and schema generation tool.

    I used to quite happily use Erwin 3.5 until Computer Associates took over development at which time the application became unstable and extremely buggy.

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684

    Designer

    I suppose the obvious one is Designer 6i. I've been using designer for quite a few years and never had any problems. The only code generation I've done with it was back in my Forms 4.5 days using Headstart which was an abortion at the time. I've heard it's improved since.

    As for schema generation, designers fine for that. Infact, I can't imagine doing a DBA job without it. The thought of typing table and index definitions in by hand brings me out in a cold sweat.

    Cheers

    [Edited by TimHall on 01-24-2002 at 07:51 AM]
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  3. #3
    Join Date
    Aug 2000
    Posts
    143
    Designer would be a good choice except we occasionally need to deploy the model onto various database problems.

  4. #4
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Designer claims to work for any ODBC compliant engine. Never tried it so I can't say conclusively if this is true or not.

    If you look at the RON you will see that you can define non-oracle databases.
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  5. #5
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    I have used Designer since 1998 and can recommend it as a good tool.

    The downside is that there is much to learn in order to use it effectively. In addition, I haven't found too many reference books for Designer.

    But you can download a trial copy from OTN and decide for yourself.

    Good luck.
    David Knight
    OCP DBA 8i, 9i, 10g

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