Note the following differences in starting and managing databases and servers:
Sybase IQ uses the server startup command start_iq, instead of the SQL Anywhere network server startup command.
Sybase IQ does not support personal servers.
Sybase IQ supports many SQL Anywhere server command line options, but not all. Other server options are supported for Sybase IQ but not for SQL Anywhere.
Sybase IQ provides the stop_iq utility to shut down servers.
Clauses permitted in the BACKUP and RESTORE statements differ in Sybase IQ and SQL Anywhere.
SQL Remote is supported in Sybase IQ only for multiplex operations.
Sybase IQ supports many SQL Anywhere database administration utilities, but not all:
The following SQL Anywhere utilities are not supported by Sybase IQ: backup, compression, console, initialization, license, log transfer, log translation, rebuild, spawn, some transaction log options (-g, -il, -ir, -n, -x, -z), uncompression, unload, upgrade, and write file.
Sybase IQ supports the SQL Anywhere validation utility only on the catalog store. To validate the IQ store, use sp_iqcheckdb.
