Using iqunload

iqunload has the same look and feel as other Sybase IQ command line tools. It also accepts the same format for command line arguments.

Unlike ALTER DATABASE UPGRADE, iqunload migrates database options. During migration, all existing database options for which values are no longer the default value are saved, and a new database is created with Sybase IQ 15.4 options. Afterwards, the saved options are applied, overwriting any Sybase IQ 15.4 options. Sybase IQ12.7/12.6 options that are no longer available in Sybase IQ 15.4 are ignored. Remember that only the catalog is re-created; no existing data in the IQ data stores is affected or changed. As an extra precaution, dbspaces are opened in read-only mode during the migration process.

This provides a window of opportunity during which you can revert back to Sybase IQ 12.7/12.6 in the event of failure.

Note: Sybase IQ15 preserves previous settings of database options and reapplies them after you create the new 15 database. You no longer need to run SELECT * from SYS.SYSOPTIONS before upgrading.

Schema Unload Mode
Running iqunload in schema unload mode generates a reload SQL file that contains all the SQL statements necessary to re-create the legacy database schema.
Database Migration Mode
Running iqunload in database migration mode starts your legacy database, then uses the Sybase IQ 15 server to re-create the catalog store.

Parent topic: Database File Migration