SQL CE and SQL Server data exchange

Background: Customer asset management projects are divided into desktop applications and PDA handheld applications, handheld applications that read information about electronic labels on assets, and are stored locally in SQL Server CE, but for statistical reports and related audit queries, SQL Server The data in CE is synchronized to the desktop database in SQL Server 2000, which means that SQL Server CE needs to exchange data with SQL Server 2000 on the desktop.

Technical essentials: The full name of SQL Server CE is Microsoft SQL Server Windows CE Edition, which provides a solution for mobile smart devices and embedded devices to access lightweight databases. With Microsoft Visual Studio.NET or Microsoft embedded Visual Tools development tools, we can extend the enterprise data management capabilities of SQL Server over the Windows CE-based smart platform. SQL Server CE can be applied to a typical environment in three.

1. The development environment, that is, for developing a desktop PC based on the SQL Server CE program, the desktop PC must include Microsoft Visual Studio.NET or Microsoft embedded Visual Tools and Pocket PC SDK development tools.

2, the client environment, is used to run the SQL Server CE program based on the Pocket PC device, when the device does not have an available network connection, you can use Microsoft ActiveSync to connect with the server environment Desktop PC cable.

3, the server environment, is the computer running Microsoft Internet Information Services (IIS) and the Microsoft SQL Server instance, which can be said to be deployed on the same computer as IIS and SQL Server. Can also be configured on more than one computer. Both RDA and merge replication require IIS to communicate with SQL Server.

SQL Server CE relies on several components for data exchange with SQL Server:
1, which is used by the database engine to manage data stores on Windows CE-based devices, and to track additions, updates, and deletions to database records;
2, SQL The Server ce Client Agent is a component that runs on a Windows CE device for connectivity, including replication objects, RDA objects, and the database engine, which you can use to control connections to SQL Server;
3, SQL Server CE The Server Agent processes HTTP requests from the SQL Server CE Client Agent. When the SQL Server CE Client Agent sends a request to the SQL Server CE Server Agent over the HTTP protocol, the SQL Server CE Server Agent connects to SQL Server and sets the queried recordset through the HT The TP protocol is then passed back to the SQL Server CE Client Agent, which relies on IIS to complete the transfer of all data.
by the above communication process we know that SQL Server CE remote connection and access requires the use of the Web Transport protocol HTTP or the HTTPS,SQL Server CE Client Agent must be running on the Windows CE device, SQL Server CE S The erver agent runs on the desktop PC, and the computer must also have IIS installed to communicate with SQL Server using RDA or merge replication. SQL Server CE supports network connectivity with Ethernet, WLAN, and wireless wide area networks. You can use a Microsoft Activesync,pocket PC device to connect directly to a SQL Server on a desktop PC using a serial, infrared, or USB connection, or you can test connectivity between SQL Server CE and desktop SQL Server. The
Remote Data Access (RDA) object is Microsoft SQL Server for Windows CE (SQL Server CE) for programmatic access to remote Microsoft SQL Server 2000 or MI Crosoft ActiveX controls for SQL Server version 7.0 databases, we can use RDA to access remote databases as simple as working on a local database on a desktop PC.

For more examples, please refer to: http://www.winbile.net/cms/News/Newsc7c60i8336.aspx

Http://www.cnblogs.com/pingkeke/archive/2006/07/12/449154.html

SQL CE and SQL Server data exchange