Make sure that the database file is not in use, and run the iqunload utility with the -au (migrate database) and -c (connection parameters) to migrate the database.
iqunload –au –c "uid=DBA;pwd=SQL;dbf=mytest" –o unload.out
The database and the iqunload utility must be on the same machine to migrate the database, or iqunload returns an error. -o is an optional switch that sends a copy of the console output to the specified log file, here named unload.out.
iqunload -au -c "dbf=/ybrown/iq-15/unload/iq127db.db;uid=DBA;pwd=SQL" Output: Sybase IQ Unload Utility Version 15.0.0.5533 Connecting and initializing Unloading user and group definitions Unloading table definitions Unloading index definitions Unloading functions Unloading view definitions Unloading procedures Unloading triggers Unloading SQL Remote definitions Creating new database Creating indexes for (1/14) "DBA"."sales_order"
Creating indexes for (2/14) "DBA"."sales_order_items" Creating indexes for (3/14) "DBA"."contact" Creating indexes for (4/14) "DBA"."customer" Creating indexes for (5/14) "DBA"."fin_code" Creating indexes for (6/14) "DBA"."fin_data" Creating indexes for (7/14) "DBA"."product" Creating indexes for (8/14) "DBA"."department" Creating indexes for (9/14) "DBA"."employee" Creating indexes for (10/14)"DBA"."alt_sales_order" Creating indexes for (11/14) "DBA"."alt_sales_order_items" Creating indexes for (12/14) "DBA"."iq_dummy" Creating indexes for (13/14) "DBA"."emp1" Creating indexes for (14/14) "DBA"."sale"
Successfully backed up file "/ybrown/iq-15/ unload/127/db/iq127db.db" by renaming it to "/ybrown/iq-15/unload/127/db/iq127db.db.before_schema_reload". Successfully backed up file "/ybrown/iq-15/unload/127/db/iq127db.iqmsg" by renaming it to "/ybrown/iq-15/unload/127/ db/iq127db.iqmsg.before_schema_reload" Successfully reloaded schema of database "/ybrown/iq-15/unload/127/db/iq127db.db".
Perform post–migration tasks. Make sure that the migration completed correctly. Back up your new databases.