Re: export / import (fwd)

On Wed, 30 Aug 2000 Sue_Davidson@exe.com.au wrote: > 1) dbschema -d databasename -t tablename to get the structure of one table, or > dbschema -d databasename -t all to get the structure of all the tables in the > database.> 3) run the output of the above into the new database to create the tables > 4) load or dbload (see the FM for syntax) to get data into specific tables > A couple of other notes: 1. You might want to include the -ss option to dbschema. It will provide the extent sizes and dbspace names for the tables (if you really need these things). 2. It's usually best to do the load or dbload AFTER creating the indexes. It helps optimize the indexes so they're in more contiguous space. This can be a hassle if you're loading multiple tables, however, because you have to edit the dbschema files to place the load statement before the indexes are created. Ron ________________________________________________________________________ Ron Flannery <mailto:rflanner@informixhandbook.com>, 248-887-8470x40 Lead author, Informix Handbook President, One Point Solutions "Your Complete Reference" "Informix & Web/Database solutions" http://www.informixhandbook.com http://www.one-point.com ________________________________________________________________________ > The iiug software repository has some improved versions of the above. > > Hope this helps. > > > > > Abraham Oommen <aoommen@redsky.com> on 30/08/2000 08:50:23 > > Please respond to aoommen@redsky.com > > To: informix-list@iiug.org > cc: (bcc: Sue Davidson/EXE) > Subject: export / import > > > > > This is a multi-part message in MIME format. > --------------D67AA9EB2ED12B69638B7299 > Content-Type: text/plain; charset=x-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.? I will be using Informix 7.3.0 for NT. > > Thanks. > > >