Copy data from live database to test database
From: Mike Taylor <mike.taylor_at_uniport.co.uk>
Date: 1998/05/18
Message-ID: <01bd8272$30fe59a0$e3aca4c1_at_ubsmct.uniport.co.uk>#1/1
Date: 1998/05/18
Message-ID: <01bd8272$30fe59a0$e3aca4c1_at_ubsmct.uniport.co.uk>#1/1
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 ?