Changes to load database

Adaptive Server 15.7 SP100 includes changes to the load database command.

The load database and load transaction commands allow you to:

Apply source database attributes to the target database using load database or (load transaction) with the with listonly=create_sql option.
Enable load database and load transaction to specify a different target database using the listonly=(create_sql, load_sql) option.
Integrate the dump history file with the Tivoli Storage Manager (TSM) being used as a repository for database and transaction log dumps.

Apply Source Database Attributes to the Target Database
With Adaptive Server 15.7 SP100, you can apply source database attributes to the target database.
Generate SQL for a Different Target Database
In Adaptive Server 15.7 SP100, you can generate SQL from the dump history file and dump information to create a new target database has a different name than the source database.
Restore Databases in Tivoli Storage Manager to Different Target Databases
With Adaptive Server 15.7 SP100, you can load Tivoli Storage Manager-based backups into a different database on a different server when using the dump history file.

Parent topic: Enhancements to Backup and Restore