Asynchronous synchronization Sql Server CE 4.0 to centralized Sql Server 2008

If Sql Server CE 4.0 is being used as an edge cache for a distributed web application, how would one asynchronously synchronize the data back to a centralized database for reporting purposes?

Secondly, would this be possible inside of shared hosting such that custom service applications/exectuables are not reasonably available?

I'm looking for actual guidance, if your answer would be "Use the Microsoft Sync framework" or along those lines please include atleast a roug开发者_JS百科h explanation of how exactly I would want to do that in a way that it makes the most sense. Optimally this would occur automatically, through some form of scheduling instead of requiring a push the button approach. If this is readily only available through push the button approach I imagine I can accomplish that through some form of restful call to "push the button".

I would write a central program (service or scheduled task) to pull (file copy(download) the sdf files form the web servers (could be via a web service exposed on each web server) and consolidate on the central DB server. Not sure what you would do with "old" data on the web servers, it depends... The same web service on each server could also take care of that.