Re: test/production setup

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 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 > >