Installing SQL Server CE Compact Edition

We program and integrate Beckhoff controls. Call us if you need help programming or starting up a Beckhoff system.

 Call +1 (763) 234-3407  Email nick@pcctrl.com

Posted to Beckhoff Blog on Aug 06, 2009


SQL Server Compact Edition (SQL Server CE) is a lightweight, yet powerful member of the SQL Server 2008 family. It can be installed on either a Windows Mobile device or on a full, desktop operating system.

For example, a common use of SQL Server CE is to store data locally on a handheld device. This is often used in data collection and inspection systems when the device is only intermittently connected to a network, or synced regularly at the end of the day. However, it is not just mobile applications that can benefit from SQL Server CE, it can be implemented on notebooks and tablets, running full blown Vista, for richer versions of client software.

Beckhoff Embedded PC Controllers running Windows CE or Embedded can use SQL Server CE as a local data store.

Steps:

Step 1. Install the correct / latest .CAB installation file.

For more information about SQL Server Compact Edition:
http://www.microsoft.com/sqlserver/2008/en/us/compact.aspx

At the time of this article the latest version is 3.5 SP1. Follow the links to the download page for this component. You will be faced with several choices, ultimately, you want: Microsoft SQL Server Compact 3.5 Service Pack 1 for Windows Mobile

Beckhoff Remote Display Utility

ftp://ftp.beckhoff.com/Software/embPC-Control/CE/Solutions/RemoteDisplay

3.5 Compact Framework Installation

c:\Program Files\Microsoft.NET\SDK\CompactFramework\v3.5\WindowsCE\

CX1020 is a x86 processor, so use: NETCFv35.wce.x86.cab

SQL Server Compact Edition 3.5 SP1 Installation

c:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Devices\wce500\x86\

SQL Server Core: sqlce.wce5.x86.CAB
SQL Replication Components: sqlce.repl.wce5.x86.CAB
SQL Development Tool: sqlce.dev.ENU.wce5.x86.CAB