Sybase Control Center lets you generate database-creation SQL for a target database
from a dump image.
Prerequisites
Backup Server must be running, and you must have dump history enabled.
Task
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.
.
- In the left pane of the Administration Console, expand .
- Click the Name field of the database for which you want to
generate a load sequence.
- Click the arrow and select Generate DDL from Dump Image to
start the wizard.
- On the Introduction screen, choose whether to:
- Generate database DDL SQL
- Display dump header contents
- 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.
- In the Target Database screen, specify the name of the target database for which
you want to generate the database DDL. If you leave this blank, the wizard creates
DDL for the database that the dump image came from.
- (Optional) Click Summary to view your selected options.
- (Optional) Click
Preview to view the SQL statement you generated with
your settings. To save a copy of the SQL statement, click
Save.