Database migration mode

Running iqunload in database migration mode (iqunload -au) performs the actual database migration from IQ 12.x to Sybase IQ 15.2. This mode does not use your existing IQ 12.x servers. Instead, database migration mode uses a special bundled server called iqunlspt bundled with IQ 12.7 ESD #5 or later.

Running iqunload -au:

  1. Starts your old database with the iqunlspt database engine.

  2. Performs internal database checks.

  3. Determines if the database is a MPX write server.

  4. Generates the schema (similar to schema unload mode).

  5. Starts the Sybase IQ 15.2 server.

  6. Creates a new database.

  7. Applies the generated schema.

  8. Backs up the operating system files. (This does not use the SQL BACKUP statement.).

See “Understanding iqunload” for information about prerequisites, syntax, and examples for using the iqunload utility in both modes.