Generating a Database Load Sequence

SAP Control Center lets you generate a load sequence.

  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases.
  2. Select one of:
    • User Databases
    • System Databases
    • Archive Databases
    • In-Memory Databases
    The Restore wizard is unavailable if you choose:
    • Temporary Databases
    • Proxy Databases
    • In-Memory Temporary Databases
  3. Click the Name field of the database, then click the drop-down arrow and select Restore.
  4. On the Introduction screen, select Generate load sequence only to generate database load sequence SQL from a specified time. You can save the load sequence SQL for future use. The load sequence consists of a batch of SQL load commands, such as:
    load database testdb from...
    load transaction testdb from...

    You may restore the database directly from the saved SQL script, either using isql or by using script functionality in ASEMAP.

  5. On the Point in Time screen, select a dump time from the list of points in time in which the database was backed up. By default, the point in time is set to the most recent database dump time.
  6. (Optional) In the Options screen, if you specified a password for backup, you must use the same password while restoring the database.
  7. (Optional) Click Summary to view your selected options.
  8. (Optional) Click Preview to view the SQL statement you generated with your settings. To save a copy of the SQL statement, click Save.
  9. (Optional) Click Save in the SQL Preview window to save the script to your local machine.