Database Repository Tool to use
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Database Repository Tool to use

  1. #1
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684

    Question Database Repository Tool to use

    Hi Guys,

    I try to find a proper tool which would do schema versioning, have central repository, schema comparison, DDL code generation & reverse engineering, fast performance.

    I evaluated 3 program products: ER/Studio, Erwin & PowerDesigner from Sybase, Oracle Change Manager - is deadly slow and keep crashing.

    Unfortunately none of them can do proper comparison & DDL code generation. They all failed during the simple test:
    1) reverse engineering schema
    2) generate DDL
    3) create new oracle schema and run DDL code
    4) compare 2 schemas.

    Obviously these 2 schemas must be identical, but they are not.

    Please advice you have in mind some other tool we could use.

    Thanks,
    Last edited by kgb; 06-10-2008 at 05:49 AM.
    Best wishes!
    Dmitri

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    ER studio can do
    1) reverse engineering schema
    2) generate DDL
    3) create new oracle schema and run DDL code

    If you want schema synchronisation then

    Embarcadero® Change Manager™

    http://www.embarcadero.com/products/...ent/index.html

    regards
    Hrishy

  3. #3
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Yes, they claim they can do it ... but this is a 9th months since they are fixing their bugs, I don't believe they ever going to fix them all.
    They probably can do reverse engineering, but if you do a simple test as I did above - you will be very surprised. Have a look attached file and you'll see the way they geneare DDL for views and execution results.

    Quote Originally Posted by hrishy
    Hi

    ER studio can do
    1) reverse engineering schema
    2) generate DDL
    3) create new oracle schema and run DDL code

    If you want schema synchronisation then

    Embarcadero® Change Manager™

    http://www.embarcadero.com/products/...ent/index.html

    regards
    Hrishy
    Attached Files Attached Files
    Best wishes!
    Dmitri

  4. #4
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Hi guys, any other advices ?
    What repository soft do you use ?
    Best wishes!
    Dmitri

  5. #5
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,471

    Talking

    Quote Originally Posted by kgb
    Hi guys, any other advices ?
    What repository soft do you use ?
    TOAD
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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