Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I would like the data in my SQL Compact database, located on a Windows CE device, to be periodically pushed to a SQL Server instance in a remote location. How would I do that? Do I need programming skills, or is it strictly configuration?

share|improve this question

SQL Server CE supports merge replication, you should be able to make use of that feature for your data syncs. Have a look at through the following on Technet (the 2nd two are linked from the first):

share|improve this answer
I'm afraid I don't understand the reference documentation you are referring to. It seems to focus on disconnected systems, where data from a "master" SQL Server database is pushed to e.g. handheld devices with SQL Compact. What I need is for my one SQL Compact database to push its recent changes to one central SQL Server. – Kristoffer Mar 31 '11 at 14:28
@Kristoffer It's a server level feature. You configure replication on the server and tell it what it needs to replicate (ie- push). Disconnected systems are just an example of where merge replication is useful. – squillman Mar 31 '11 at 14:33
So SQL Server can be configured to pull data from SQL Compact? Is that described anywhere? – Kristoffer Mar 31 '11 at 14:36

Microsoft SQL Server Compact 3.5 supports three methods of connecting to and exchanging data with a SQL Server database: remote data access (RDA), merge replication, and Sync Services.

share|improve this answer

Your Answer


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.