We've been evaluating different methods of data synchronisation (especially between occasionally connected clients and servers) on an almost ongoing basis and looking at Sync Services for a while. One of the drawbacks has always been that it only easily supported SQL Server Compact Edition "out of the box".
In this article however Liam Cavanagh mentions...
We have just posted a new sync sample to our Code Gallery that demonstrates how to enable offline data collection applications to synchronize a SQL Express client database to another SQL Server database using the Synchronization Services for ADO.NET library. In this scenario, SQL Express client databases can be used as client databases to a central ADO.NET enabled database. Unlike the existing peer-to-peer synchronization SQL Express provider sample which you may have seen, this sample is optimized for a hub-and-spoke topology.
Comments