Howdy all,

I'm going to be developing an application that will run at many physically distributed sites. This application will regularly need to commit it's data to a centrally located home office. Data is going to be pushed both ways (from client to home and home to client) and will need to be fairly regularly (once an hour at least).

The sites will have internet access, but not necessarily broadband. I expected the backend database to be SQL Server.

What would you guys recommend for this data transfer? Does SQL Server offer an efficient web-based replication? I'm not looking for an exact answer, just a discussion about possible options.

Thanks for your input!

--Ben