- Introduction
- Pocket Access
- SQL Server CE
- Development Options
- Data Synchronization
- Conclusion
Data Synchronization
As I mentioned earlier, the data synchronization capabilities of Pocket Access are fairly basic. APIs are provided to support the programmatic synchronization of tables between desktop and device, but that's about it. SQL Server CE goes much further in this area by providing two means of synchronizing a CE-based database with an enterprise SQL server. The first method uses Remote Data Access (RDA) objects to perform a push/pull sync between the mobile device and server. It does this through the use of a SQL FILTER statement, allowing the developer to customize the flow of data between databases. The second option, known as merge replication, uses the publish/subscribe model to sync data publications to a variety of subscribing devices. Both RDA and merge replication make use of IIS (and HTTP as the transport).