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