How to select the correct SQL Server compact edition (sqlce) Installation Package

Abstract: The installation package of SQL Server compact edition consists of three functions, which distinguish between the CPU platform and the operating system platform. Beginners often do not know how to distinguish them. This article introduces the installation packages of SQL Server compact edition, so that you can know how to differentiate and select them.

If you are using Visual Studio 2005/2008 for development. the SQL Server compact edition database is used in the program. When Visual Studio deploys your program to a device (or simulator, the SQL Server compact edition is automatically deployed together. If you develop native code applications, You need to manually deploy the SQL Server compact edition installation package. In addition, you also need to manually deploy SQL Server compact when deploying applications for end users devices.

The installation packages of SQL Server compact edition are stored in the following locations, which are currently called the "root directory" of the installation package ":

Version Number	Path
3.0/3.1	% Program Files %/Microsoft Visual Studio 8/smartdevices/SDK/SQL Server/mobile/V3.0
3.5	% Program Files %/Microsoft SQL Server compact edition/v3.5/devices

The root directory contains two subdirectories: wce400 and wce500, which respectively store the installation packages for the operating system platform with Windows CE 4.0 and Windows CE 5.0 as the kernel. The Windows Mobile 2003 and Windows CE 4.0 SQL Server compact edition installation packages are in the wce400 directory; the Windows Mobile 5.0/6.0/6.1 and Windows CE 5.0/6.0 SQL Server compact edition installation packages are in the wce500 directory.

Directory	Platform
Wce400	Windows Mobile 2003, Windows CE 4.0, and Pocket PC 2003
Wce500	Windows Mobile 5.0/6.0/6.1, Windows CE 5.0/6.0

Open the wce500 directory, and you can see some subdirectories named after the processor. The directory names are armv4i, misiⅱ, misii_fp, misiv, misiv_fp, sh4, and x86. The CPU of Windows Mobile devices generally belongs to armv4i, while Windows CE depends on the specific hardware.

Open the armv4i directory and you can see some. CAB files. The following table describes the functions and application platform of each installation package file based on SQL Server compact edition 3.1:

Installation Package	Platform	Function
Sqlce30.wce5. armv4i. Cab	Windows CE	Engine
Sqlce30.ppc. wce5.armv4i. Cab	Windows Mobile Pocket PC	Engine
Sqlce30.phone. wce5.armv4i. Cab	Windows Mobile Smartphone	Engine
Sqlce30.repl. wce5.armv4i. Cab	Windows CE	Merge replication
Sqlce30.repl. PPC. wce5.armv4i. Cab	Windows Mobile Pocket PC	Merge replication
Sqlce30.repl. Phone. wce5.armv4i. Cab	Windows Mobile Smartphone	Merge replication
Sqlce30.dev. enu. wce5.armv4i. Cab	Windows CE	Query Analyzer
Sqlce30.dev. enu. PPC. wce5.armv4i. Cab	Windows Mobile Pocket PC	Query Analyzer
Sqlce30.dev. enu. Phone. wce5.armv4i. Cab	Windows Mobile Smartphone	Query Analyzer

From the table above, we can see that the installation packages of SQL Server compact edition are divided into three functions: Engine, merge replication, and query analyzer. Each function is divided into Windows CE, windows Mobile pocketpc and Windows Mobile Smartphone. Therefore, the armv4i directory contains nine. Cab installation packages. In many cases, you only need to install the engine. If you need to enable SQL Server compact edition to support RDA or merge replication data synchronization, you need to install the merge replication component; if you want to directly use the query analyzer on your device to create, open, and query the SQL Server compact edition database, or debug programs on your device, you need to install the query analyzer component. That is to say, the engine component is required, and the merge replication and query analyzer components are optional.

Each component installation package contains different files, which are listed in the following table:

Installation Package	Include files
Sqlce.Platform. Processor. Cab	Sqlcese30.dll Sqlceqp30.dll Sqlceme30.dll System. Data. sqlserverce. dll
Sqlce30.repl.Platform. Processor. Cab	Sqlceca30.dll Sqlceoledb30.dll Sqlcecompact30.dll
Sqlce30.dev.Lang.Platform. Processor. Cab	Isqlw30.exe Sqlceerr30Lang. Dll

 

If your device cannot run normally after SQL Server compact is installed, check whether the correct version is installed?