• Yes I would go with the replication as well.

    or you can use help of SSIS, with Lookups and Union.

    but again that would make your system slow, since you do not have enough streaming.