Use qexpt command line tool to export the database schema together with database data.
qexpt enables a quick and clean database migration in case of necessity.
qexpt [options] database
Options:
-o [ --output ] arg (=.) --format arg (=fgl) --stdout -v [ --verbose ] -V [ --version ] -? [ --usage ] -h [ --help ] -d [ --database-driver ] arg --database arg |
Output directory Output format (fgl, xml, sql) Direct output to stdout Verbose output Print version Show usage information Show help information Database driver List database schemas to export |
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