Marcus,

Merge replication is the correct choice. You will probably want a third SQL Server installation that is your "Master" copy, with the two locations as the Subscribers.

If the database will not grow too large, you can buy one SQL Server license for the primary server and use MSDE at the two locations.

>Hi,
>
>we are setting up a scenario, where we have to locations, both filling up their SQL Database with the local data. The two SQL Servers shall replicate their data, so at the end we have the same data on both systems.
>
>Can we use SQL Server Merge replication for thos task or what is recommended?
>
>TIA
>Marcus