Generating a Database Load Sequence

Sybase 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. In the list of databases that appear, click the Name of the database for which to generate a load sequence.
4. Click the arrow and select Restore to start the Restore wizard.
5. On the Introduction screen, select Generate load sequence only to generate database load sequence SQL from a specified time. You can save the load SQL for future use. The load sequence consists of a batch of load SQL, 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.

6. 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.
7. (Optional) In the Options screen, if you specified a password for backup, you must use the same password while restoring the database.
8. (Optional) Click Summary to view your selected options.
9. (Optional) Click Preview to view the SQL statement you generated with your settings. To save a copy of the SQL statement, click Save.
10. (Optional) Click Save in the SQL Preview window to save the script to your local machine.