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. See “Sybase IQ 15.1 Unload utility (iqunload)” for additional options.
This example migrates the simplex database mytest and saves output in unload.out in the current directory:
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. The -o is an optional switch. that sends a copy of the console output to the specified log file, here named unload.out.
Because the example specified DBF=mytest.db,
the iqunload utility attempts to connect to this
database in the current directory. You could also specify the full
path to the database, as shown in the following example:
iqunload -au -c "dbf=/ybrown/iq-15/unload/iq127db.db;uid=DBA;pwd=SQL" Output: Sybase IQ Unload Utility Version 15.0.0.5120 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".
