2

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)?

Thanks, Stuart

asked Sep 28, 2011 at 18:39

1 Answer 1

1

My understanding (I haven't worked with this in over a year) is that "merge replication" requires a sql server instance to act as a publisher. If you want to only have an SQL CE database at each end, you need to write your own code with sync framework (if you see articles on "sync services" they are using the sync framework).

answered Sep 29, 2011 at 16:13
0

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.