• 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.