Hi Musiccrazy,
First of all, thanks for considering to use SyncFx for your next solution.
by reading your description above, I think the SyncFx would be a good fit to your scenario and requirement ( as such high level). briefly, the Sync Services for Ado.net V3.0 which is part of the SyncFx2.0 package will enable you to synchronize your data among different SqlServer ( or SQLCE ) endpoints. it supports Ntier sync(i.e. IIS as the mid tier ) which one of your request is.
it is very simple to use as well and we have a lot of samples/tutorials published to help users to develop the solutions based on the SyncFx.
you can get more details ( and the answers to address the other questions above ) here: http://msdn.microsoft.com/en-us/sync/bb887608.aspx
Please let us know if you need more info on SyncFx. I will be interested in knowing details about your scenarios as well if you can share with us.
Thanks
Yunwen
This posting is provided "AS IS" with no warranties, and confers no rights.