RE: Migration vs. New install 7.3 to 9.2

The format of the database.sql file has changed in 9.21. DBEXPORT is still there and you can export and import to 9.21. Wayne E. Martin Informix Database Administrator Kmart Corp. -----Original Message----- From: Jay Aymond [mailto:jaymond@communitycoffee.com] Sent: Tuesday, January 02, 2001 2:49 PM To: informix-list@iiug.org Subject: Re: Migration vs. New install 7.3 to 9.2 We will also be upgrading from 7.31 to 9.2 in the next few months. I had planned on doing an in-place upgrade to save time (we currently have about 65 GB of data). You are saying that if I do this, I will no longer be able to use dbexport to export my data??? I use ontape as our nightly backup, but I use dbexport / dbimport to move data from our production machine to our development machine. -- Jay Aymond Community Coffee Art S. Kagel <kagel@bloomberg.net> wrote in message news:3A5226CD.28B0262E@bloomberg.net... > The only problem with upgrading in place to 9.2 is that upgraded tables/ > databases cannot be dbexported. If your backup/safety strategy includes > using dbexport you must consider exporting/importing or copying into a clean > 9.2 instance. > > Art S. Kagel > > Doug Fossmeyer wrote: > > > > Hello all, > > > > Does anyone have any recommendations on migration strategies? Our > > production server is hp-ux 11 and 7.3 IMFX. I am debating whether to do a > > clean install of 9.2 as a new instance of IMFX and then migrate the data > > over -or- create a second 7.3 instance and then upgrade to 9.2. Any > > thoughts on which is the best strategy? Any reasons either will not work > > or whether I will have problems in execution? > > > > tia > > > > Doug