Re: Migrating from 7.31 to 9.20

Obnoxio The Clown wrote: > > From: Ram.Mohan.Kompella@banctec.com > > > >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. > > Are you implying that my recommendations aren't up to snuff? :-) > > I think (and this is just a thought) that an in-place upgrade from 7.31 to > 9.21 should be fairly painless. Didn't I just say that? I'm sure I just said that! Art S. Kagel > >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 > > > > > > > > > > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com