Re: Informix 5, How to copy a table / database, HELP!

> (I'm not a DBA, that is clear!) > A client has a Production database and a test database, to test sertain > conversions in the database we need to copy tables or the whole database > from the production into the test situation, is there a command for > this? > or is there any other way to do this? > ------------------------------------------------------------ > Hans.Nieuwenburg@Cmg.Nl Hans, I would recommend that you should do this operation with the utmost care. If you are using OnLine I would recommend most strongly that you implement 2 instances one for production and one for testing. Then you select the production instance, do a DBEXPORT of the database, select the test instance, and do a DBIMPORT. That is the safest way. Then make sure that test accounts can only use the test instance, whereas production databases use the production instance. It sounds simple, but if you need help please call. Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc