up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
feedback

2 Answers

up vote 0 down vote

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

link|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
feedback
up vote 0 down vote

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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