Re: Export/Import Database - Help??

Let's not forget that the 6.0 version of dbschema, using the -ss option, DOES retain this information. In article sah@emory.mathcs.emory.edu, melin@hermes1.sps.mot.com (Darin Melin) writes: >On 27 Oct 1994, Peter Wiley - Poultry wrote: > >> Assuming you have Informix >=4.00 release, then >> >> dbexport <your-database-name> >> >> will create a subdirectory calles <dbname>.exp and write the complete SQL >> script necessary to recreate the schema and dumps all the data to ASCII >> files. Works great. dbimport rebuilds the database. >> >> Peter Wiley >> > >Yes. it does work, but I don't know about great. There are numerous >downfalls with dbexport and dbimport such as: > > In Standard Engine: > ------------------ > > 1) path locations of the *.dat and *.idx files are not > written into the sql file. > > 2) porting to the On-line engine requires numerous > modifications (see below). > > In On-Line Engine: > ----------------- > > 1) dbspaces are not written to the sql file. > 2) extent sizing " " " " " " > 3) locking info " " " " " " > >There are several schema programs avail that do give you the missing info >(esp with on-line engine). Please contact me if you need this info. > >Regards, > >Darin > >+----------------------------------------------------------------------------+ >| | | >| . . | | >| ... ... | Darin Melin | >| ..... ..... | Software Engineer, DBA | >| .. ... .. | Business Systems Integration Group | >| . . . | Semiconductor Products Sector | >| | Mesa, AZ | >| Motorola, Inc. | rp29560@email.sps.mot.com Phone:(602)-655-3627 | >| | melin@hermes1.sps.mot.com | >| | VP - Arizona Informix Users Group | >+----------------------------------------------------------------------------+ >| 'connectionLESS IS MORE' -- Data Broker | >+----------------------------------------------------------------------------+ > >