Re: test/production setup

Sean Kelsey wrote: > > If you are using Informix SE ( not Online ) then copying the database should > be a piece of cake - with the following assumptions:- > the "testmydb" is exactly the same as "mydb" > all of the db tables are located in the database directory and NOT in > another directory ( unless, of course they are symbolically linked ) > > You should be able to copy the isam tables directly from the directory of > the one database to the other ( include the system catalog tables was > well ). If you use transaction logging you will need to turn this off in th eold db and back in the new one because the location of the log filew is stored in the system tables. > > If your using OnLine 5, then you may need to use tbunload, dbunload or > dbexport ( I can't remember which is the better one !! ) > > Supervisor wrote in message <7488vk$hgp$1@xenon.inbe.net>... > >Hi, I'm currently working on a project for a client that has Informix 5.0.4 > >on a HP UNIX server. > > > >We have of the same database a production database 'mydb' and a test > >database 'testmydb'. > >We now want to be ably to reguraly copy the production database to the test > >database. > >How can this be performed in IX ? > > > >Are there any dba utility tools available to do this ? > >Or will we have to write sql-code ? If so, are there any parameters we > >should be carefull of ? > > > >Thanks > >Michel Kennis > >E&Y Consulting > > > > -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 -- If all else fails, read the instructions and the release notes. Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/