Data exchange between SQL ce and SQL Server

Background: Customer asset management projects are divided into desktop applicationsProgramAnd PDA handheld applications, handheld applications read information about electronic tags on assets, and save it in the local SQL Server ce, but in order to carry out statistical reports and related audit queries, data in SQL Server ce needs to be synchronized to SQL Server 2000 in the desktop database, that is, SQL Server ce needs to exchange data with SQL Server 2000 on the desktop.

Technical Points: The full name of SQL Server CE is Microsoft SQL Server 2000 window ce edition. It provides a lightweight Database Access Solution for mobile smart devices and embedded devices. With Microsoft Visual Studio. NET or Microsoft Embedded Visual tools, we can extend SQL Server's enterprise data management capabilities to a Windows CE-based smart platform. SQL Server CE can be applied to a typical environment in section 3.

1. the development environment is used to develop a desktop PC based on the SQL Server ce program. The desktop PC must include Microsoft Visual Studio. NET, Microsoft Embedded Visual tools, and Pocket PC SDK development tools.

2. The client environment is a Pocket PC device used to run SQL Server Ce-based programs. When the device has no available network connection, microsoft ActiveSync can be used to establish a cable connection with the desktop PC in the server environment.

3. The server environment is a computer that runs Microsoft Internet Information Service (IIS) and Microsoft SQL Server instances. You can deploy IIS and SQL server on the same computer, it can also be configured on multiple computers. RDA and merge replication all need to communicate with SQL Server through IIS.

SQL Server ce relies on several components to exchange data with SQL Server:
1. The database engine is used to manage data storage on Windows CE devices, and tracks the addition, update, and deletion of database records.
2. the SQL Server ce client agent is a component used for connection on a Windows CE device, this includes copying objects, RDA objects, and database engines. These object applications can control the connection with SQL Server;
3. the SQL Server ce 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 HTTP, the SQL Server ce Server Agent connects to the SQL Server and sends the queried record set back to the SQL Server ce client agent over HTTP. All data must be transmitted through IIS.
we know from the above communication process that the web transmission protocol HTTP or HTTPS is required for the remote connection and access of SQL Server ce. the SQL Server ce client agent must run on a Windows CE device, the SQL Server ce Server Agent runs on a desktop PC, and the computer must also have IIS installed to use RDA or merge copies to communicate with SQL Server. SQL Server ce supports Ethernet, wireless LAN, and wireless WAN. By using Microsoft ActiveSync, the Pocket PC device can use a serial port, infrared ray, or USB to directly connect to the SQL server on the desktop PC, or test the connection between SQL Server ce and the desktop SQL Server.
the Remote Data Access (RDA) object is Microsoft SQL Server 2000 Windows CE (SQL Server CE) activeX controls for programmable access to remote Microsoft SQL Server 2000 or Microsoft SQL Server version 7.0 databases. You can use RDA to access remote databases as easily as operating local databases on a desktop PC.

For more instances, see: http://www.winbile.net/cms/News/Newsc7c60i8336.aspx

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