You can move a database from one platform to another as long as both platforms share the same endian structure. To move your database to a different platform, move your database first, then migrate your data.
- 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.
- Start Interactive SQL and issue the database upgrade
statement.
For example:
ALTER DATABASE UPGRADE
Note: If the current version of Sybase IQ is higher than the version on which this database was running you will need to upgrade the database.