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

RDA and merge replication architecture

Figure 7-9. RDA and merge replication architecture

When data is required from the central ...

Get Microsoft® Mobile Development Handbook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.