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) |
|
--stdout |
Direct output to stdout |
|
-v [ --verbose ] |
Verbose output |
|
-V [ --version ] |
Print version |
|
-? [ --usage ] |
Show usage information |
|
-h [ --help ] |
Show help information |
|
-d [ --database-driver ] arg |
Database driver |
|
--database arg |
List database schemas to export |
| --table-only | Include tables, views, and synonyms only instead of all the database definitions and data |
| --system-tables | Include the system catalog tables in the schema |
Here is an example which loads the database schema into "test1" folder in SQL format from an Informix database called "stores":
qexpt -o /home/informix/Desktop/test1 --format sql -d informix --database stores