What database are you using? We have Oracle and utilize archive log shipping to replicate our data to our reporting database. We also use Oracle Active Data Guard on our reporting database so that we can query it while data is being replicated to it.
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
