Asynchronous synchronization Sql Server CE 4.0 to centralized Sql Server 2008?

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.

Well that certainly could be an option, but this seems like it would be the absolute sledgehammer approach if every other option fails for some reason. Also I'd have concerns about even being able to reliably copy the file as it would be in use. – Chris Marisic Jul 15 at 15:01 SQL Compact has no issues with copying files in use... – ErikEJ Jul 16 at 7:29 I still extremely dislike this answer, but you deserve the bounty for atleast saying anything on here.

– Chris Marisic Jul 21 at 20:00 Thank you very much! – ErikEJ Jul 22 at 8:42.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.