Re: Migrating from 7.31 to 9.20

Obnoxio The Clown wrote: > 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. > While it would be nice to use method #2, in my case with a 500,000,000 row database on a 24X7 schedule, I cannot to do the export/import method in my maintenance window. I have already upgraded a 7.31 test system to 9.21.uc1 with no problems. Actually I would prefer method #3 which is to build a new instance and import the data and run them in parallel for the short time necessary to validate the new install/import. This method, however, requires enough disk space available to run both at the same time. And OTC is correct in that you cannot go to Quiescent but have to shut down completely. > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com