ESAT ERKEC (9/25/2012)
Maybe SSIS execute sql task
This gets my vote as what you after is a denormalised version of the data which logshipping and replication is not going to give you (without a lot of development anyway).
With some sort of change tracking, timestamp etc you can update only what has changed as well.