Re: Copy data from live database to test database

Mike Taylor wrote:
>
> We have wo databases, one for LIVE transactions and the other for
> testing/training, hence called TEST.
>
> I would like produce a script for updating the TEST database with all the
> transactions currently in the LIVE database.
>
> Note : The TEST database will be inactive at the time the copy is
> performed.
>
> How best can this be achieved ?

Export the PROD database.

Then import data into the TEST one.

You can do it with a shell script.

-- 
HTH.

dorr_at_cetrel.lu