Re: Copy data from live database to test database
From: Umesh Jagannatha <umesh_at_esystem.com>
Date: 1998/05/22
Message-ID: <6k4c4e$lvt_at_colossus.holonet.net>#1/1
Date: 1998/05/22
Message-ID: <6k4c4e$lvt_at_colossus.holonet.net>#1/1
In article <01bd8272$30fe59a0$e3aca4c1_at_ubsmct.uniport.co.uk>,
mike.taylor_at_uniport.co.uk says...
>
>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 ?
>
>
You can do this using the standby database option. That is the fastest way to copy data from. You can even script that. It works great.
Thanks
Umesh Jagannatha
umesh_at_esystem.com
Received on Fri May 22 1998 - 00:00:00 CEST