Perform these steps to move a database to another platform with the same
endian structure.
Platforms must share the same endian structure. Move your database, then migrate your
data.
- Back up the database.
- Shut down the SAP Sybase IQ server.
- Install the server on the new platform. Your migration can take place on the
same or a different machine.
- Start the 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.
- Start Interactive SQL and run ALTER DATABASE UPGRADE.
Note: If the SAP Sybase IQ version is more recent than the
version on legacy platform, you must upgrade the database.