SAP IQ - Generating Database Schema using iqunload utility
Tags:
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]$