I have an application that uses SQL Server CE 3.5. I am trying to expand the database to have a remote database accessible from various locations. I will need both the local (which might or might not have consistent internet connections) and the remote databases to be able to sync with one another and to be able to send and receive updates from the other database upon internet connection.
Is it possible to replicate an embedded database such as SQL Server CE with another embedded database or do you have to set up a server for this functionality? If not, what would be a recommended server database to use (preferably to be set up on a cloud server)?