Converting to a new hardware platform

Sybase IQ supports migrating your database from one platform to another, as long as both have the same endian structure. If you are upgrading from a previous version and want to move your Sybase IQ databases to a different supported hardware platform, perform the conversion before you upgrade your data to Sybase IQ 15.1.

NoteNotes

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

  1. Back up the database.

  2. Shut down the Sybase IQ server.

  3. Install the Sybase IQ 12.x server on the new platform. Your migration can take place on the same or a different machine.

  4. Start the Sybase IQ server on the new hardware platform.

  5. Connect to the utility database, utility_db.

  6. Restore the database from the backup you created in Step 1.

  7. 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 startup 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.

  8. 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.

NoteNow that your database has been converted to the new platform, you can proceed with migrating the 12.x database to Sybase IQ 15.1.