Database File Migration

Upgrading from Sybase IQ 12.6/12.7 to Sybase IQ 15.4 requires database file migration instead of a simple database upgrade. Sybase IQ 15.4 includes tools to ensure a smooth and error-free migration.

iqunload is a fully-automated migration tool included with Sybase IQ 15.4 that recreates the catalog store and reloads it with the existing database schema metadata. Only the catalog is recreated; the IQ data and temp dbspaces are not changed.

The migration process is completely automated, self-contained, and does not require your existing Sybase IQ12.6 or 12.7 software. There are a few pre-migration steps you need to follow to ensure a smooth and error-free migration.

• Migration Modes
  iqunload has two working modes: schema unload and migration.
• Embedded Sybase IQ 12.7 Engine
  iqunlspt is a self-contained subset of the Sybase IQ 12.7 (ESD #5) database engine that provides support for legacy database unloads. iqunlspt is installed with Sybase IQ 15.
• 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.
• Understanding Data Storage Changes and Schema Reload
  Migrating to Sybase IQ 15.4 creates a new catalog store and changes some Sybase IQ 12.7/12.6 options.
• Before and After Migration Files
  Migration generates a set of files from your legacy database. Migrating the IQ 12.7 demo database to Sybase IQ 15.4 creates this set of corresponding files.