Migrating the Legacy 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).

This command 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. -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 can also specify the full path to the database, as shown here:

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.