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

> 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? You can use the UNLOAD and LOAD commands from within dbaccess and use dbschema to create the table layouts, or you can use dbexport to dump the entire database and dbimport to reload it, or you can use the tbunload and tbload commands. My personal choice would be dbexport. HTH. -- Ciao, Billy +------------------------------------------------------------------------------+ | Billy Wheeler Junior Programmer / Director The West Solutions Group | +------------------------------------------------------------------------------+ | Oracle isn't the answer. Oracle is the question, and the answer is "no". | +------------------------------------------------------------------------------+