Synchronizing Data Using SQL Server 2005 Compact Edition Remote Data Access
Many applications require you to load data from a central database, make changes or additions locally, and then send your changes back to the central SQL Server database so that other users can see them. Remote Data Access (RDA) is one technique you can use for loading from a central SQL Server database and sending updates back to the server at a later time.
RDA makes use of the SQL Server CE Database Engine and the SQL Server CE Client Agent on the smart device client. (See Figure 7-9.)
Figure 7-9. RDA and merge replication architecture
When data is required from the central ...