Upgrading non-multiplex databases

Table 4-1 lists steps for upgrading non-multiplex servers and databases to Sybase IQ 12.7. Details follow the table.

Table 4-1: Upgrading non-multiplex databases

To do this ...

See ...

1. Shut down servers

“Shutting down servers”

2. Install IQ

“Installing IQ”

3. Start the server

“Starting the server”

4. Upgrade databases

“Upgrading databases”

5. Enforce referential integrity

“Enforcing referential integrity”

6. Verify after upgrade

“Verifying databases after upgrade”

7. Back up databases again (recommended)

“Backing up databases after upgrade”

Before you upgrade

You must have a recent backup before you upgrade to a major release of Sybase IQ.

If you anticipate a need to restore data to its previous version after you upgrade, read “Restoring to your previous version after upgrade” before you begin the upgrade process.

If you have multiplex servers, instead of following the steps in this section follow those in “Upgrading 12.5 multiplex databases to 12.7” or “Upgrading 12.6 multiplex databases to 12.7”.