Schema Unload Mode

Running iqunload in schema unload mode generates a reload SQL file that contains all the SQL statements necessary to re-create the legacy database schema.

You can use schema unload mode to create an empty version of a database. When you execute iqunload in schema unload only mode, using the command line argument -n, a file that contains all the SQL necessary to create the database schema is created.

Once the schema SQL file is generated, manually create a new database and execute the generated SQL file. No data is migrated. To migrate data into the new database, manually extract the data from your older database and manually load it into the new database.

Schema unload mode does not use the special unload support engine that comes with Sybase IQ 15.4. To run the schema unload mode, you must connect to your existing Sybase IQ database server.

Related concepts
Database Migration Mode