SQL Server 2005 to SQL Server CE Merge Replication?

You can setup just the SQLCompact Server Tools on a separate web server running IIS which will host the sql compact merge replication dll's. Then you don't have to open any direct web access to your SQL Server, but Sql compact will still be able to sync via web through the web server. Another note, the web server box hosting IIS will barely get any CPU usage and just some flat files written for the sync so it can be a pretty basic box.

You can setup just the SQLCompact Server Tools on a separate web server running IIS which will host the sql compact merge replication dll's. Then you don't have to open any direct web access to your SQL Server, but Sql compact will still be able to sync via web through the web server. Another note, the web server box hosting IIS will barely get any CPU usage and just some flat files written for the sync so it can be a pretty basic box.

All in all I would recommend looking into the Microsoft Sync Framework formerly ADO. Sync Services. It is a much more flexible solution allowing the developer to really customize every part of the syncronization process including filtering data, syncing directly between clients, conflict resolution, your choice of transfer protocol and better scaling ability than merge replication all without having to be locked into SQL Management studio and have the internals hidden from you.It was built by the same team that build replication for sql server.

If you go the replication route check out Rob Tiffany's book and his Microsoft Blog. "Enterprise Data Synchronization with Microsoft SQL Server 2008 and SQL Server Compact 3.5 Mobile Merge Replication".

Seems like this should be a ServerFault question.

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.