Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2004
    Posts
    21

    create a DB schema from DDL

    Hi,

    Does anyone know i f there is any good tools that can create
    a DB schema from DDL?
    I know that PowerDesigner can do it but it is quite expensive.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    If you have the DDL script, just play it. Use the script tool for your database engine, and you ought to be "good to go" with a database.

    -PatP

  3. #3
    Join Date
    Oct 2004
    Posts
    21
    Thanks for your reply Pat.

    The problem is that I don't understand your answer.
    (maybe because English is not my native language and also because
    I'm new to databases)

    I have generated DDLs from Sybase Central but I don't have PowerDesigner
    that can do a "reverse engineering" from the DDLs and create a nice DB Schema.
    So what do you mean with "Use the script tool for your database engine"?

    Hans

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    I'm assuming that you mean that you have a script of DDL including statements like CREATE TABLE. If that is the case, then the script is actually intended to be played via ISQL.EXE or whatever tool you'd normally use to issue a SELECT, INSERT, DELETE or similar statement. You shouldn't need any special tools to execute DDL.

    -PatP

  5. #5
    Join Date
    Oct 2004
    Posts
    21
    Ok Pat,

    Than we missunderstood each other. My question wasn't clear enough.

    Thank's anyway,
    Hans

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Maybe I understand your question better (then again, maybe I don't).

    Are you trying to create an ERD (Entity-Relationship Diagram) from an existing database? In other words, do you already have the database (not a script to build a database), and you want a picture that shows the schema of that database graphically?

    -PatP

  7. #7
    Join Date
    Oct 2004
    Posts
    21
    Yes, that's right.

    I have a database (Sybase) and from that I have used Sybase Central
    to generate the DDLs that builds up the dB.
    And just as you say, it would be good if there was some tool that could
    show a "picture" of it (ERD).

    I know that PowerDesigner can do this but are there any other tools that
    can create an ERD from DDLs?

  8. #8
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    There are many tools that can create an ERD from a database.

    PowerDesigner is a good choice, especially for a Sybase database (for obvious reasons). ErWin is quite expensive, but it is certainly the "tool of choice" for data modeling professionals. Microsoft offers a variety of tools that can produce ERDs.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •