MS SQL Data Warehousing - Best Process for datawharehouse

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Best Process for datawharehouse

Kenneth H. Brannigan

2006-02-07, 8:23 pm

Hello,
We have a client database that gets pyrged ona nightly basis. We need to
have a copy of the database at our location with all the data since the
begining of time. I would like to know the best method of doing this? The
transfer of data can only happen once a day. Is there a way to handle this by
playing the transaction ,log back ignoring delete executions? Any help is
much appreciated.
Thanks,
Ken

Sponsored Links