Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    12

    Lightbulb Unanswered: Create Database scripts

    Is there a way to generate 'Create Database' script that truely reflects an existing database?! I am planning to use this script to recreate a database exactly same as it was before.

    I was looking at db2look command. However, the scripts it generates won't create database.

    Thanks ahead for any advice.

  2. #2
    Join Date
    Dec 2002
    Location
    Little Rock, AR
    Posts
    17

    Re: Create Database scripts

    Originally posted by KenWhite
    Is there a way to generate 'Create Database' script that truely reflects an existing database?! I am planning to use this script to recreate a database exactly same as it was before.

    I was looking at db2look command. However, the scripts it generates won't create database.

    Thanks ahead for any advice.
    If you have the Quest Central Software for DB2, you can extract the DDL by right-clicking on the existing database.
    Laura Smith, DBA

Posting Permissions

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