Migrating databases to a 64-bit system

This section describes how to migrate your database from a 32-bit to a 64-bit hardware platform.

The procedures assume your database is already upgraded to Sybase IQ 12.7.

1. Back up the database.

2. Shut down the server.

3. Install the Sybase IQ 64-bit software and any required ESDs.

4. If the current version of Sybase IQ is higher than the version on which you were previously running, start Interactive SQL and issue the database upgrade statement:

   ALTER DATABASE UPGRADE

   If the database was created with the Java options off, append the keywords JAVA OFF JCONNECT OFF to the preceding command.

5. Start the server.

Sybase recommends that you perform regular backups.