| marcmc 2005-04-18, 11:23 am |
| Hi all,
I have a requirement to automate the process to take a production database
to my main test server on a regular basis.
I have not done this before in a datawarehouse, only replication and bkup &
restore on medium size client databases. Any ideas on approaches to the
design are most welcome.
Part of the requirement is to keep at a minimum any disruption to the
production database and not to compromise performance on same.
The datawarehouse is loaded from an AS400 through a main DTS.
I have had a number of ideas including replication, bkup & restore but these
seem like they would deliver a major hit on the production server!?! Our
window for doing this would be quite small, maybe an hour.
Grabbing the AS400 extracts and applying the DTS on the main Test Server
while polling the variuos extracts to ensure they are finished/validated is
another approach, one which I quite like. I would do this through a dotNet
application.
Any ideas / experiences?
Marc
|