Migrate your simplex database

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".