Remote data access (RDA) in Microsoft® SQL Server™ 2000 Windows® CE Edition (SQL Server CE) provides a simple way for a Microsoft Windows CE-based application to access (pull) data from a remote SQL Server database table and store that data in a local SQL Server CE database table. The application can then read and update the local SQL Server CE database table. SQL Server CE can optionally track all changes that are made to the local table. The application can later update (push) the changed records from the local table back to the SQL Server table.
Windows CE-based applications can also use RDA to submit SQL statements to be executed on a remote SQL Server database. For example, an application could submit SQL statements that insert, update, or delete records to a remote SQL Server table. Applications can invoke any SQL statement that does not return a recordset, including a stored procedure on the remote system. RDA is appropriate when the full functionality of SQL Server CE merge replication, such as conflict resolution, is not required.
SQL Server CE communicates with SQL Server through Microsoft Internet Information Services (IIS). By connecting through IIS, RDA takes advantage of IIS authentication and authorization services. SQL Server can be located behind a firewall or be accessed with Microsoft Proxy Server. RDA can be performed over both local area networks (LANs) and wide area networks (WANs).
RDA is well suited to wireless transports. Compression is used to reduce the amount of transmitted data. Encryption can be used to safeguard sensitive user data during transmission.