Moving a database to another Adaptive Server  Using the special dump transaction options

Chapter 11: Developing a Backup and Recovery Plan

Upgrading a user database

You can load dumps into the current version of Adaptive Server from any version of Adaptive Server that is at version 11.9 and later. The loaded database is not upgraded until you issue online database.

The steps for upgrading user databases are the same as for system databases:

  1. Use load database to load a database dump of a version 11.9 or later Adaptive Server. load database sets the database status to “offline.”

  2. Use load transaction to load, in order, all transaction logs generated after the last database dump. Load all transaction logs before going to step 3.

  3. Use online database to upgrade the database. The online database command upgrades the database because its present state is incompatible with the current version of Adaptive Server. When the upgrade completes, the database status is set to “online,” which makes the database available for public use.

  4. Make a dump of the upgraded database. A dump database must occur before a dump transaction command is permitted.

For more information about load database, load transaction, and online database, see the Reference Manual.





Copyright © 2005. Sybase Inc. All rights reserved. Using the special dump transaction options

View this book as PDF