Microsoft® SQL Server™ 2000 Windows® CE Edition (SQL Server CE) supports two methods of connecting to and exchanging data with a data source:
- Remote data access (RDA)
- Merge replication
These connectivity solutions use the authentication, authorization, and encryption services of Microsoft Internet Information Services (IIS). The connectivity can be performed over wired and wireless LANs and WANs. You can configure Microsoft ActiveSync® 3.5 or ActiveSync 3.1 with SQL Server CE Relay, to use the network connection on a desktop computer to communicate with SQL Server. This eliminates the requirement for the Windows CE-based device to have a network card or modem.
RDA provides a simple way for a Windows CE-based application to access data located in a remote SQL Server 7.0 or SQL Server 2000 database. You can use RDA when you do not need the full functionality of merge replication. You can use RDA without configuring SQL Server replication or creating publications.
Applications can use RDA in two ways: The application can submit a data manipulation language (DML) statement that is forwarded to the SQL Server system for execution, or the application can supply an SQL query that returns a rowset. The resulting rowset is transmitted to the Windows CE-based device where it is stored in a table. All changes made by the application are optionally tracked, and at the request of the application, the updated rows are sent back to the server, where they are applied to the SQL Server database.
For more information, see Using Remote Data Access (RDA).
Merge replication in SQL Server CE is based on the merge replication implemented in Microsoft SQL Server 2000. Merge replication is suited to portable devices because it enables data to be updated independently on the portable device and the server. The data on the device and the server can later be synchronized when the device is connected to the server.
Common scenarios for merge replication include: read-only replication; data capture and upload; and replication, updating and synchronization. Most applications use a combination of these scenarios. For example, a sales support application might use read-only replication to download a price list to a device while relying on data capture and upload to capture new orders on the device and then upload them to a server.
You can use both horizontal and vertical filters to define and maintain unique subsets of data for different clients or groups of clients. Horizontal filters can be used to replicate a subset of the rows in a published table. Vertical filters can be used to replicate a subset of the columns in a published table.
For more information, see Using Replication.