Conversion of System and Database

Subject: Upgrading OS & Informix Date: Fri, 3 Sep 93 9:40:06 EDT Message-Id: <9309030940.aa02360@goofy.unifi.com> >-We bundle Informix with our product. Till date the products in the field >-run Informix 4.0 on Odt1.1(Unix 3.2). We have decided to upgrade the product >-to Informix 5.0 running on Odt2.0(Unix 3.4). Challenge is to upgrade both >-SCO-Odt and Informix in the field simultaneously. ...text deleted here >- >-What would general approach for upgrade be? >- ....text deleted here... >-c. Use UNLOAD for all tables Odt1.1 Informix 4.0 >- Save all ascii files >- Load Odt 2.0 and Informix 5.0 >- Extract all ascii files, LOAD tables into database >- >- This option which uses intermediate ascii form for data transport will >- work but needs data transfers which could be too resource (time,space) >- consuming. >-Bharat. >-======================================================================== >-Bharat Shah - Principal Database Engineer Voice: (508)-663-7570 >-Unifi Communications Corp. Fax: (508)-663-7543 >-4 Federal St, Billerica, Mass 01821, USA bharat@unifi.com >-======================================================================== Sir, The times I have had experience with doing conversions, not necessarily Informix, I find that option c above, if possible, is the safest and surest. Usually, if I plan to try one of the other ways, I try to make sure that I have my records unloaded into ascii, if at all possible. Cheryl Gross Red River Army Depot Texarkana, Texas cheryl@redriverad-emh1.army.mil (903)334-3518