Re: export / import

--Boundary_(ID_wWXbS/SVxBc4p2KToKMSNg) Content-type: text/plain; charset=us-ascii Content-disposition: inline Content-transfer-encoding: 7BIT Abraham 1)Is there a way to export just the database objects without the data. dbschema 2)Export by user? Not AFAIK, but you can get the list of tables for a given user like so: select tabname from systables where owner = "user_name";and run dbschema individually (or via a script) using dbschema. 3)Import just the schema. dbaccess dbname file_generated_by_dbschema 4)Import data from specific tables and/or user? See answer to 2 above. You will need the dbaccess LOAD statement. 5)In NT is the export/import conducted using a command line or is there a GUI tool? No idea. You can probably run it from the command line in a DOS window. HTH Sujit Abraham Oommen <aoommen@redsky.com> on 08/29/2000 02:50:23 PM Please respond to aoommen@redsky.com To: informix-list@iiug.org cc: Subject: export / import --Boundary_(ID_wWXbS/SVxBc4p2KToKMSNg) Content-type: text/plain; charset=iso-8859-1 Content-disposition: inline Content-transfer-encoding: quoted-printable This is a multi-part message in MIME format. --------------D67AA9EB2ED12B69638B7299 Content-Type: text/plain; charset=3Dx-user-defined Content-Transfer-Encoding: 8bit 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. 2)Export by user? 3)Import just the schema. 4)Import data from specific tables and/or user? 5)In NT is the export/import conducted using a command line or is there= a GUI tool? Any help would be appreciated.=A0 I will be using Informix 7.3.0 for NT= . Thanks. --------------D67AA9EB2ED12B69638B7299 Content-Type: text/x-vcard; charset=3Dx-user-defined; name=3D"aoommen.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Abraham Oommen Content-Disposition: attachment; filename=3D"aoommen.vcf" begin:vcard n:Oommen;Abraham tel;fax:713-354-1600 tel;work:713-354-1538 x-mozilla-html:FALSE url:www.redsky.com / www.nuforia.com org:Red Sky;Systems Integration adr:;;4203 Yoakum Blvd., Suite 100;Houston;TX;77006;US version:2.1 email;internet:aoommen@redsky.com title:Systems Engineer fn:Abraham Oommen end:vcard --------------D67AA9EB2ED12B69638B7299-- = --Boundary_(ID_wWXbS/SVxBc4p2KToKMSNg)--