Migrating across hardware platforms [CR 445754]

This section was omitted from Chapter 3, “Migrating Data from Previous Versions,” in the Sybase IQ Installation and Configuration Guide.

Sybase IQ supports migrating your database from one platform to another, as long as both have the same endian structure.

Platforms with big-endian structure are:

AIX64
HP-UX64 PA-RISC
HP-UX64 Itanium
IBM Linux on POWER
SunOS64

Platforms with little-endian structure are:

Linux32**
Linux64
Windows 32
WinAMD64
SunAMD64

Sybase IQ 12.6 ESD #2 and higher releases support migration between Windows and Linux.

IMPORTANT! ** If you created your Sybase IQ database on a Linux 32-bit version prior to Sybase IQ 12.6 ESD #2, you must first install IQ 12.6 ESD #2 for Linux 32-bit systems and create a new data backup before migrating to another platform.

Migrating a database from one platform to another (same endian structure)

Back up the database.
Shut down the Sybase IQ server.
Install the Sybase IQ server on the new platform. Your migration can take place on the same or a different machine.
Start the Sybase IQ server on the new hardware platform.
Connect to the utility database, utility_db.
Restore the database from the backup you created in Step 1.
Shut down the server and restart it against the restored database. If the current version of Sybase IQ is higher than the version on which you were previously running, you need to upgrade databases, and therefore restart the server in a way that restricts user connections. Sybase recommends using two server start-up options:
- Use -gd DBA so that only users with DBA authority can start and stop databases.
- Use -gm 1 to allow a single connection plus one DBA connection above the limit so that a DBA can connect and drop others in an emergency.
An alternate way to restrict connections is to specify
```
sa_server_option 'disable_connections', 'ON'
```
on the connection where you intend to perform the upgrade and
```
sa_server_option 'disable_connections', 'OFF' 
```
on the same connection after upgrading. The disadvantage is that this method precludes emergency access from another DBA connection.
Start Interactive SQL and issue the database upgrade statement. For example:

ALTER DATABASE UPGRADE

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

For more information, see “Upgrading non-multiplex databases,” in Chapter 3, “Migrating Data,” in the Sybase IQ Installation and Configuration Guide.