Unfortunately, we are forbidden (for various, nonsensical reasons) from pulling data from the production DB outside of the overnight window.

So, would you recommend something other than snapshot replication for this? (Or, if snapshot is indeed the best method, is there a smooth way to overcome the dependencies problems I referred to in my earlier post?)

Thanks.