Read the Sybase IQ Release Bulletin for the latest information. See the special installation instructions section in the release bulletin for any installation instructions not included in this document.
Upgrade Sybase IQ. If you are migrating from a version prior to 12.6, you must upgrade to Sybase IQ 12.6 or later. All migration paths assume that you are migrating from Sybase IQ 12.6 ESD 11 or Sybase IQ 12.7 ESD 5.
Sybase IQ 12.6 and higher versions do not support existing LONG BINARY columns created using any release prior to Sybase IQ 12.5 ESD8. You must explicitly drop LONG BINARY columns before migrate 15.1, and recreate them after installing. For details, see “Upgrading existing LONG BINARY columns” in Large Objects Management in Sybase IQ.
The SORTKEY function now uses the International Components for Unicode (ICU) library, instead of the Sybase Unicode Infrastructure Library (Unilib®). Sort key values created using a version of Sybase IQ prior to 15.0 do not contain the same values created using version 15.0 and higher. You should regenerate any sort key values in your database that were generated using a version of Sybase IQ prior to 15.0.
Sybase IQ 15.1 no longer supports the creation of custom collations. If you are rebuilding a database with a custom collation, the collation is preserved if you rebuild in a single step. If you choose to unload the database and then load the schema and data into a database that you create, then you must use one of the supplied collations.
Backup your current installation and save copies of any changes you made to default login and post login scripts. Create your backups on removable media, like tape, DVD, or CD. Make sure the backups are readable before you proceed.
Review and understand the database migration utilities. Sybase IQ 15.1 includes an iqunload utility that you can use to recreate the schema for your database or simply migrate your database from 12.x to 15.1. An iqlsunload utility is available for 12.7 multiplex users who need to move local stores. Understanding these utilities before you begin can help you plan your migration more effectively.
Resolve potential migration errors before you migrate. Sybase IQ 15.1 no longer supports some 12.x features and objects. You must update these objects before you begin for the migration utilities to function correctly.
Follow the work flows for the migration you want to perform. There are separate migration paths for simplex and multiplex databases. See “Migrating simplex databases” and “Migrating multiplex databases” additional information.
