Are you implying that my recommendations aren't up to snuff? :-)Quote:
>I am in the database world for the last 5 years working on Informix ( as
>as O and S )
>Is any body sure out there that there are changes in storage data
>from 7.31 to 9.20 ?
>dbexport and dbimport is okay for small databases. What if the Database
>a Terrabyte and above. I do not think Informix can afford recommend
>and 'dbexport' as a practical solution.
I think (and this is just a thought) that an in-place upgrade from 7.31 to
9.21 should be fairly painless.
> >>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?
> >>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,
> >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 --
> >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
>even try an in-place upgrade.
>Louisville, KY USA
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com