Re[2]: Migrating from 7.31 to 9.20

Hello everybody I am in the database world for the last 5 years working on Informix ( as well as O and S ) Is any body sure out there that there are changes in storage data structures from 7.31 to 9.20 ? dbexport and dbimport is okay for small databases. What if the Database size is a Terrabyte and above. I do not think Informix can afford recommend 'dbimport' and 'dbexport' as a practical solution. Any ideas ??? Ram ____________________Reply Separator____________________ Subject: Re: Migrating from 7.31 to 9.20 Author: "David Weis" <dweis@louisville-i-market.com> Date: 7/10/00 8:54 AM Obnoxio The Clown wrote in message <8kc48c$jp6$1@news.xmission.com>... > >From: dins dins <dins_d@yahoo.com> >> >>So, which way would be better to ugrade database from >>IDS 7.31 to IDS 9.20? >> >>1) To take backups from database, go to Quiescent mode >>and install new version over older? >> >>OR: >> >>2) install 9.20, take dbexport from IDS 7.31 and >>import it to 9.20? > >Call me old fashioned, but I prefer 2). Also, I don't think 1) will work, I >think you have to first revert to 7.30 then upgrade to 9.20. I could be >wrong, though. Oh, and going Quiescent will probably not work anyway -- you >can't overwrite a file that's in use, IIRC. I guess I am old fashioned, too. I prefer exporting the data and then importing it to the new version for all upgrades --- guess I find too many cases where there is bad data (ugh!) or many tables with MULTIPLE extents to even try an in-place upgrade. David Weis Louisville, KY USA dweis@louisville-i-market.com Voice: 502-637-7316