Skip to Content
SAP IQ

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]$

No comments