qexpt

qexpt is a command line tool to export the database schema together with database data.

Enables a quick and clean database migration in case of necessity.

Syntax

qexpt [options] database

Options

-o [ --output ] arg (=.)

Output directory

--format arg (=fgl)

Output format (fgl, xml, sql), the default is fgl

--stdout

Direct output to stdout

-v [ --verbose ]

Verbose output

-V [ --version ]

Print version

-? [ --usage ]

Show usage information

-h [ --help ]

Show help information

--dd-format arg (=none)

Download table data format (none, inplace, unl, csv); default is none

-e [ --encoding ] arg

Output encoding

-d [ --database-driver ] arg

Database driver

-b [--database] arg

List database schemas to export

-t [ --database-type ] arg

Database type (default is same as database driver)

-c [ --database-conn-str ] arg

Connection string for ODBC driver

-s [ --database-dsn ] arg

System DSN name for ODBC driver (alternative to connection string)

-u [ --database-user ] arg

User name for ODBC driver (alternative to connection string)

-p [ --database-pwd ] arg

User password for ODBC driver (alternative to connection string)

-n [ --no-keys ]

Skip writing primary and foreign keys

-i [ --no-indices ]

Skip writing indices

-l [ --late-foreign-key-decls ]

Declare foreign keys as separate constraints (fgl and sql)

--tables-only

Include tables, views, and synonyms only instead of all the database definitions and data. Note: If a synonym refers to the table from another database, it will be loaded to the schema as a full table, and all views will be loaded as a full table.

--system-tables

Include the system catalog tables in the schema. They are skipped by default.

 

Here is an example of the command that exports the database schema to the "test1" folder in SQL format from an Informix database called "stores":

qexpt -o /home/informix/Desktop/test1 --format sql -d informix --database stores

 

 

 

Contact Us

Privacy Policy

Copyright © 2026 Querix, (UK) Ltd.