PPC DB Sync
Posted on 2009-02-23
I have an application that will reside on the PC and a Pocket PC. Basically the user will use the Pocket PC application in the field. He will come back after a days work and dock the pocket PC.
The pocket pc application creates/uses a database utilizing sqlCEServer framework. The PC side will be using sql 2005 express server. I want to have the data on the pocket PC pulled to the PC.
1. I will use openNetCF notify me when a sync is needed (PC side).
2. I will use Microsoft Synchronization Services for ADO.NET to help me sync the data.
There does not seem to be a lot of information on how to do this.
Am I going in the correct direction? Does anyone have any pointers, some code that shows how to do this, or knows of some good sites to guide me through this process.
I am unclear on how everything pieces together.
Do I initiate the sync from the PC or the pocketPC.
Any help would be awesome, I have been digging around on the web for a while not finding a complete solution!