Re: Xfer from Test to Devel

Naibin Chen wrote: > > Carlson@WHSmith wrote: > > > Steve Romankiw wrote: > > > > > > When we transfer between Test and Development (located on same machine), I > > > typically do an DBEXPORT from test followed by an DBIMPORT into > > > development. This is a slow process. > > > > > > > Sounds like you're looking for a full dataset. > > > > > Are other options available? For instance, can I create a onpload image > > > of my test environment, unload test, and reload into development using the > > > image. > > > > We've been quite successful in restoring a production level0 archive to > > our test system. We have identical logical layouts between systems. > > MUCH faster than dbexport/dbimport or unload/load. > > > > John Carlson > > Informix DBA > > WH Smith, Inc. > > I have identical logical layouts for Prod db instance and Test db instance on > thesame Unix machine, because they have different instant name I wasn't able to > Xfer > with ontape and have to use dbimport. Does your systems located on the same > machine or on a different machine? > > Naibin Chen Oh great . . . NOW I actually read the original post. Unfortunately, the words "same machine" are just now registering. Too much coffee, I guess . . . 8-) My recommendation will work where test and prod are on different boxes. Unfortunately, the only thing that I know would work on the same box would be 'dbexport/import', 'unload/load', or 'onunload/onload' Sorry for the confusion . . . John Carlson Informix DBA WH Smith, Inc.