Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2012
    Posts
    1

    Unanswered: DB2 DDL statements for diff between two versions of the schema

    I need to generate the DB2 DDL statements for diff between two versions of the schema. I can't use a GUI tool or TOAD.

    Is there a script that I can use from command line that will give me the DDL statements for diff between two versions of the schemas.

    I have found a tool for MySQL, and am looking for a similar tool for DB2.

    Please help.

    thanks,
    Rak

  2. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Which release/level of DB2 running on which operating environment?

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by rakou View Post
    I can't use a GUI tool or TOAD.
    Why not? Sounds like an arbitrary restriction.

    You can always extract a database DDL script with a command line tools and do whatever you want with it using your choice of a graphic interface (IBM Data Studio, Toad, etc.)
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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