Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

2 Answers

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
add comment

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. http://msdn.microsoft.com/en-us/library/ms171801.aspx

share|improve this answer
add comment

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.