Re[2]: Restoring 7.1x data to 7.2x instance

We have successfully taken a 7.14 database backup and restored it to a 7.23UC3 engine several times. As long as the usual applies between your test system and production (size and devices are the same) it shouldn't be a problem. It goes through the physical restore and logical restore, and then rebuilds the sysmaster database. Informix tech support told us that it could not be done but it seems to work. Let me know if there are any potential problems with this that I am not seeing. Craig Lanford Mailto:craig.lanford@alltel.com David Williams wrote: >> >> In article <34E375F6.EBC@bellsouth.net>, W. H. >SMITH > <carlson1@bellsouth.net> writes >> >Got a good one for you . . . >> > >> >Test system: Production system: >> >7.23.UC4 OnLine 7.13.UC1 OnLine > >HPUX 10.01 HPUX 10.01 >> > >> >We are currently in the process of upgrading a third-party software >> >package, which means converting their current database into their >'new' > >database. We've made the first run with a few glitches and >we're ready > >for a second run (something about user documentation <G>). The new > >software requires 7.23 (finally keeping up with the times somewhat), > >hence the discrepancy between systems. > > > >We need to move the data from the production system to the test system. > >I'm already familiar with dbexport/dbimport; I've written a script to > >handle that aspect. Due to the amount of data to move, I really don't > >want to do that. Is there any way to take a level0 from the 7.13 > >instance and restore it to the 7.23 instance without using > >dbexport/dbimport or unload/load? Reinstalling the 7.13 engine > Only by reinstalling 7.13 on the test system. You would need to > delete $INFORMIXDIR, oninit -i and the restore a level 0 archive. > > At the binary (page) level I doubt they would be the same. > Since we have 4gl, isql, esql/c also installed, could I reinstall 7.13 to a different directory, reset $INFORMXDIR, and enable the 7.13 engine from there? John Carlson Informix DBA WH Smith, Inc. > >temporarily is an option, if necessary; I'm not just sure how the > >reinstall should work. > > > >Any ideas? I know it's a bit strange; usually one goes forward, not > >backward. We will go forward eventually (April), but only after the > >second upgrade/conversion run is complete. > > > >TIA > > > >John Carlson > >Informix DBA > >WH Smith, Inc. > > -- > David Williams