Re: Load/Unload Nuances

dbexport/dbimport will save you a lot of hassles trying to dbload tables in the proper order to avoid constraint violations. dbimport will load the tables, build the indexes, and finally put all the contraints on. Clean/Simple/Smokin' Fast ----- Original Message ----- From: "aspiring immigrant" <keepitliteus@yahoo.com> To: <informix-list@iiug.org> Sent: Monday, June 30, 2003 11:22 AM Subject: Load/Unload Nuances > Hi Guru's, > A question on unloading/loading data. > I want to un,oad data from one Informix DB and load it onto another. > If time is not a constraint to do this, is it necessary to drop the > indices before loading the data ? > 2. Is dbload a better way to load data as it also logs the details of > rows loaded. > > 3.Also , is it a good idea to sort the data before loading the data ? > My guess is there may be a difference in the indexing process, if data > is already sorted. (Although we cannot ensure it always in the real > world). Since we can sort data when we migrate, is it a good idea to > sort and then load ? > > Thanks in Advance! > and any other ideas are most welcome. > > Thanks sending to informix-list