Sybase IQ 15.0 includes many new features: enhanced multiplex capabilities, table spaces and data partitioning that support Information Lifecycle Management (ILM) capabilities and extensive query parallelism. Additionally, its class-leading performance has also been significantly strengthened. To achieve this, parts of the server have undergone substantial changes; in the case of the catalog store; a new storage format has been adopted.
The catalog store in Sybase IQ 12.7 worked with all earlier versions of the product; the server included logic that supported all functionality in each earlier version. Database migration was straightforward - users simply performed an "alter database upgrade" when upgrading to the next version of Sybase IQ. This simple process was called upgrading the database. From an engineering perspective, however, the support for legacy versions imposed severe limitations, making it cumbersome to deliver new and innovative features. Additionally, legacy code also restricted the type of optimizations that could be performed.
As part of the upgrade to Sybase IQ 15.0, a database file migration is now required, rather than a simple database upgrade. A new fully automated migration tool - iqunload - included with Sybase IQ 15.0, re-creates the catalog store and reloads it with existing database schema metadata. Only the catalog is re-created; the IQ data and temp dbspaces are not changed.
The migration process is completely automated, self-contained, and does not require your existing Sybase IQ 12.7 software. There are a few premigration steps you need to follow to ensure a smooth and error-free migration.
This document provides a brief introduction of the migration tool and process that should be followed to do the migration.