Generating Database-Creation SQL from a Dump Image

Generate database-creation SQL for a target database from a dump image.

Backup Server must be running and you must have dump history enabled. To enable dump history, use:
sp_configure 'enable dump history', 1
See Utility Guide for details on backupserver.

The Generate DDL from Dump Image wizard generates database-creation SQL using information from the dump image. It extracts device and segment mapping information from dump images, then generates a sequence of create database and alter database commands, ensuring that you can create an exact copy of the same data and log segment layout for your target database.

  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases.
  2. Click the Name field of the database, then click the drop-down arrow and select Generate DDL from Dump Image.
  3. On the Introduction screen, choose whether to:
    • Generate database DDL SQL.
    • Display dump header contents.
  4. In the Image screen, select a dump image from the list of available images from which to generate your database-creation SQL. By default, the wizard selects the most recent image.
  5. In the Target Database screen, specify the name of the target database for which to generate the database DDL. If you leave this blank, the wizard creates DDL for the database that the dump image came from.
  6. (Optional) Click Summary to view your selected options.
  7. (Optional) Click Preview to view the SQL statement you generated with your settings. To save a copy of the SQL statement, click Save.