WinCE data Communication SqlCe data Synchronization Chapter

The previous article summarized the wince through the webservice to carry on the data communication The interactive way, today collates a SqlCe data synchronization way content. First of all, the software environment: the terminal platform uses wince5.0+sqlce2.0, the server uses Windows Server 2003+sql Server2000 Sp4,dot Net framwork uses version 2.0.

Data synchronization between SQL Server CE and SQL Server through RDA merge replication. Remote data Access (RDA) consists of three main components: SQL Server CE database Engine, SQL Server CE Client agent, and SQL Server CE Database agent. The SQL Server CE database engine is responsible for writing and reading data from the SQL Server CE database; The SQL Server CE Client Agent is the main component of RDA on mobile devices, and it implements the main functionality of RDA, and we can call the interface it provides to control RDA The SQL Server CE server-side proxy is located on the server side, communicates with the SQL Server CE Client Agent through the HTTP protocol, and receives and processes commands for the SQL Server CE Client Agent. The communication principle structure of the following diagram:

The environment configuration for data synchronization is also divided into: Terminal SqlCe configuration, IIS proxy configuration.

Terminal SQLCE configuration: Install terminal and PC Sync program Microsoftactivesync, locate VS2005 installation directory D:\Program Files\Microsoft Visual Studio 8\smartdevices\sdk\ SQL server\mobile\v2.0\wce400\ Armv4 under the Sqlce20.dev.ppc.wce4.armv4.CAB and Sqlce20.ppc.wce4.armv4.CAB, copied to the terminal wince system, installed in the terminal two packets, installed in the terminal Windows directory will add three files: Ssce20 . dll, Ssceca20.dll, and Sscemw20.dll. Added a directory SqlCe 2.0 in the Windows directory, where Isqlw20.exe is a similar SqlServer2000 Query Analyzer that runs under WinCE, and can be fired wince into the system while firing the SQLCE operating system.

IIS proxy configuration: IIS proxy server for GPRS communication, it is best to have static IP. Install IIS and SqlServer2000 on the proxy server, install SQL Server CE2.0 on the IIS proxy server, and configure options during Setup

Here, enter the alias of the virtual directory and the SqlCe installation directory, I entered the virtual directory name is SqlCE20, because I also configured a SqlCE3.0 version:-) Go on