Sybase IQ supports migrating your database from one platform to another, as long as both have the same endian structure. See Table 3-2 and Table 3-3. In these tables, the source platform is the horizontal axis and the target platform, the vertical axis.
Sybase IQ 12.6 ESD2 or higher supports migration between Windows and Linux.
Platform |
AIX64 |
HP-UX64 PA-RISC |
HP-UX64 Itanium |
IBM Linux on POWER |
SunOS64 |
|---|---|---|---|---|---|
AIX64 |
12.5 to 12.6 |
12.5 to 12.6 12.6 to 12.6 |
12.5 to 12.6 12.6 to 12.6 |
12.5 to 12.6 12.6 to 12.6 |
12.5 to 12.6 12.6 to 12.6 |
HP-UX64 PA-RISC |
12.5 to 12.6 12.6 to 12.6 |
12.5 to 12.6 |
12.5 to 12.6 12.6 to 12.6 |
12.5 to 12.6 12.6 to 12.6 |
12.5 to 12.6 12.6 to 12.6 |
HP-UX64 Itanium |
12.5 to 12.6 12.6 to 12.6 |
12.5 to 12.6 12.6 to 12.6 |
12.5 to 12.6 |
12.5 to 12.6 12.6 to 12.6 |
12.5 to 12.6 12.6 to 12.6 |
IBM Linux on POWER |
12.6 to 12.6 |
12.6 to 12.6 |
12.6 to 12.6 |
Not a migration |
12.6 to 12.6 |
SunOS64 |
12.5 to 12.6 12.6 to 12.6 |
12.5 to 12.6 12.6 to 12.6 |
12.5 to 12.6 12.6 to 12.6 |
12.5 to 12.6 12.6 to 12.6 |
12.5 to 12.6 12.6 to 12.6 |
Platform |
Linux32 |
Linux64 |
WIndows32 |
|---|---|---|---|
Linux32 ** |
12.5 to 12.6 |
12.5 to 12.6 12.6 to 12.6 |
12.5 to 12.6 12.6 to 12.6 |
Linux64 |
12.6 to 12.6 |
12.6 to 12.6 |
|
Windows32 |
12.5 to 12.6 12.6 to 12.6 |
12.5 to 12.6 12.6 to 12.6 |
12.5 to 12.6 |
IMPORTANT!
** If you created your Sybase IQ database
on a Linux 32-bit version prior to Sybase IQ 12.6 ESD2, you must
first install IQ 12.6 ESD2 for Linux 32-bit and create a new data
backup before migrating to another platform.
Migrating a database from one platform to another
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, 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.
For more information, see “Upgrading servers and databases to 12.6”.
