TOAD Like Schema Script generation but...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: TOAD Like Schema Script generation but...

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Posts
    26
    TOAD has a nifty feature (DBA->Generate Schema Script) that generates all of the DDL required to rebuild a schema. Hoewever, even with the "Sort for Creation" option enabled it doesn't analyse dependencies, rather it just exports everything in alphabetical order. This causes the creation of the schema to fail because constraints can't be enabled if the referenced table doesn't exist. e.g. Table A has a foreign key constraint on a column in Table B. Table A will obviously be created before table B, and when it is altered to enable the FK then because table B hasn't been created then Oracle will throw a fit.

    Does anyone know if there are any other tools that offer this kind of functionality, but with dependency checking as well? I've heard ERWin mentioned a few times but not sure whether this is what I need?

    Just for clarity it needs to be able to handle all kinds of db objects (e.g. tables, pl/sql procedures, views, ...).

    Thanks very much,

    Matt

    [Edited by ca9mbu on 11-02-2001 at 04:40 AM]

  2. #2
    Join Date
    Jun 2001
    Location
    NJ
    Posts
    118
    HI ca9mbu,
    toad normally generates in alphabhetical order if you want to have the constraints as Alter statements. It works well for me in that way.

    Thanks.
    GD_1976

  3. #3
    Join Date
    Jan 2001
    Location
    San Diego, CA
    Posts
    81
    PATINUM ERWIN is a produc of computer assosiates http://www.ca.com,

    yes it does have what you desire., but it costs coocoo bucks.....It works well though.It's an actually a DB design tool, not like a TOAD which is primary a SQL editing +more features. ERWIN can "reverse engineer" schemas, can compare schemas, etc............

    Eugene

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

    Talking

    Hello

    There is a product called DBA-artisan that can do this thing what you are looking for.

    regards
    Hrishy

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