• Yes, Updates, deletes, selects etc. need to be performed at both sites!

    Is it still the best way?

    quote:


    Do you need to have all the changes made at the subscriber to be replicated to your publisher?

    With merge replication, you will have the same db in both servers, even when both are making changes to the db.

    But if you need to have the same db, and the subscriber to start only, then you could use once snapshot replication... or even restore the db and each subs.