Oninit cdi / Archive
Talk to an expert →

Re: Migrating from 7.31 to 9.20

Posted in 2000

Topics: Installation, Setup & Upgrades, Storage & Space Management, Migration, Import/Export & Data Conversion, Versions, Editions & End-of-Life

David Weis — — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to David Weis
Thomas Parsli — — source: Informix-list mailing list archive (1991-1998)

"David Weis" <dweis@louisville-i-market.com> writes: > 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. AOL! >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. Yes -this is a great time to reduce extents, implement fragmentation, delete some old users, old tables and unused SPLs ;) Thomas

Glossary