We are implementing a new system by a client and we will have the database in both the client's office as well as the web-hosting facility. This is so that the company can function even if the connection to the internet fails -- and it does way too often. We are currently using SQL 2000 and have this set up with Merge Replication, however it is a big overhead and we feel it is too heavy for what we are doing -- but it works. We are getting web orders and they are processed in the office. Phone orders that are entered in the office will also be trackable by users online etc....This is the main jist of it, but it is way too complicated to write custom procedures to constantly handle the transfer of data. We are planning to have an additional web location and will need all databases to be synced. What is the best way to do this? We need the best quality solution. Speed of transfers is good, but a 5-10 minute delay will not make a difference.