Restoring from a compatible backup

RESTORE lets you restore database files for Sybase IQ 12.0 and up. Due to changes in the format of the database, Sybase IQ 12.0 does not let you restore from a backup created on an 11.x version. Likewise, you cannot restore an 11.x IQ database from a Version 12.0 backup.

To move your data from a Sybase IQ 11.5.1 database to Sybase IQ 12.7, you must:

  1. Upgrade to 12.5 using the migration procedure described in the version 12.5 Sybase IQ Installation and Configuration Guide.

  2. Follow the migration procedure for 12.5 databases described in the 12.7 Sybase IQ Installation and Configuration Guide.

RESTORE does not let you restore an Sybase IQ backup to an Adaptive Server Anywhere database.