export / import
Posted in 2000
\
Abraham Oommen wrote:
>
> I am a newbie to Informix and wanted to know some info on exports and
> imports.
>
> 1)Is there a way to export just the database objects without the data.
dbschema is the Informix utility to create an SQL schema file. There is
also my own replacement utility myschema in the package utils2_ak in the
IIUG Software Repository.
> 2)Export by user?
What do you mean 'by user'?
> 3)Import just the schema.
Isn't that the same as #1? Same answer too dbschema/myschema.
> 4)Import data from specific tables and/or user?
Import implies to take data into a table. Do you mean export? There are
several:
dbexport
onunloadthe dbaccess UNLOAD verb (see the SQL Users Guide)
> 5)In NT is the export/import conducted using a command line or is there
> a GUI tool?
Commandline tools.
> Any help would be appreciated. I will be using Informix 7.3.0 for NT.
>
> Thanks.
Art S. Kagel