Re : dbexport Slow

You may want to use the following : Unload the data : unlaod to , select * from Step 1 ) Write SQL : select 'unload to',tabname ,'.unl','select * from',tabname where tabid > 99 , output this to a .sql file. 2) Run this SQL 3) This will export the roes from the database, 4) You may want to perform the dbschema For loading data : load from insert into Step 1) Write SQL : select 'load from',tabname'.unl','insert into',tabname where tabid > 99 . output this to .sql file. 2) Run the script (.sql ) Load the data 3) Rebuild the indexes 4) update statistics This runs much faster thna the dbexport / dbimport. Best of luck Ashutosh In article <354F4EA9.5BA1@Non-HP-Roseville-om1.om.hp.com>#1/1, GREG_MAY@Non-HP-Roseville-om1.om.hp.com wrote: > > dbexport exports a complete database. But, its way too slow. Is there > a way to export and load a database faster. > > g. > -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading