SAP IQ - Generating Database Schema using iqunload utility

SAP IQ  IQ 15.4 esd 5.x and later and SAP 16.x support iqunload migration utility for extracting database schema,

For extracting database schema, start source IQ server and use iqunload -n for generating database schema. -c switch is required for specifying connection parameters,.

iqunload -n -c "uid=DBA;pwd=sql;dbf=/work/demo1611/iqdemo.db"

SAP IQ Unload Utility Version 16.0.0.2014

Connecting and initializing

2016-02-12 10:37:28 Unloading user and group definitions

2016-02-12 10:37:28 Unloading spatial units of measure

2016-02-12 10:37:28 Unloading spatial reference systems

2016-02-12 10:37:28 Unloading sequences

2016-02-12 10:37:28 Unloading table definitions

2016-02-12 10:37:32 Unloading text configurations

2016-02-12 10:37:32 Unloading materialized view definitions

2016-02-12 10:37:33 Unloading index definitions

2016-02-12 10:37:33 Unloading functions

2016-02-12 10:37:33 Unloading view definitions

2016-02-12 10:37:33 Unloading procedures

2016-02-12 10:37:33 Unloading triggers

2016-02-12 10:37:33 Unloading SQL Remote definitions

2016-02-12 10:37:33 Unloading MobiLink definitions

Successfully unloaded schema from database "/work/demo1007/iqdemo.db".

[demo1611]$