Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question

migrated from stackoverflow.com Sep 29 '11 at 11:22

This question came from our site for professional and enthusiast programmers.

1 Answer 1

up vote 1 down vote accepted

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

share|improve this answer
    
Thanks! That's exactly what I was looking for. –  Stuart Sep 29 '11 at 17:09

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.