Syncing SQL Server CE over web service with SQL Server 2005

Question

Hi,

Hi, I have a client winforms which creates xml-s with objects. Once a month I get this xml-s and save theirs in my database(a lot of columns, and fields).

Now, I want to get this reports more often and omit serialization and deserialization.

I'm only interested in Microsoft technology so if is it impossible to sync sql ce(in my winforms application) over webservice(asmx) with sql server 2005 ?

Do you know any good example to cope with this situation ?

Answer 1

B"H

You are lucky.

Your scenario seams to be the exact scenario that the development team envisions as its primary use.

I think http://code.msdn.microsoft.com/sync/Release/ProjectReleases.aspx?ReleaseId=3423 would be an example closest to your scenario.

Answer 2

Hi. I have found an example how to sync MS SQL Compact using MS Synchronization services in web service here. Also, if you get stuck with this approach here it is another approach for synchronizing SQL Compact.