SAP Sybase IQ 12.7 Database Migration

Updating a 12.7 catalog to 16.0 requires a database file migration, not a simple database upgrade. Migration tools bundled with SAP Sybase IQ 16.0 can recreate the legacy database schema and database options.

• Preparing to Migrate
  Perform these tasks before you migrate your database.
• Migration Utilities
  Utilities and support tools bundled with SAP Sybase IQ.
• 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 SAP Sybase IQ 12.7 are initially set to run in SAP Sybase IQ 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.