Updating a 12.7
catalog to 16.0 SPx requires a
database file migration, not a simple database upgrade. Migration tools bundled with
SAP Sybase IQ
16.0 SPx can recreate the
legacy database schema and database options.
Migration Issues
SAP Sybase IQ no longer supports some legacy features. Run iqunload in schema unload mode to generate a script (reload.sql) that contains the entire database schema. Compare the contents of this file to find unsupported syntax and metadata.
Unloading Legacy Schemas
To unload legacy schema, run iqunload in schema unload mode (iqunload -n ) on the same machine as the legacy schema.
Migrating Legacy Databases
Run iqunload in database migration mode (iqunload -au) to migrate a legacy database.
Postmigration Tasks
SAP Sybase IQ 16 databases upgraded from 12.7 are initially set to run in 15.x compatibility mode. To complete the change from 15.x to 16.0, you must explicitly change several 15.x compatibility settings to complete the 16.0 upgrade.