Beckhoff Automation Blog

The Beckhoff Blog contains posts relating to Beckhoff Automation programming and technology. Select a post below to view the full story and details.

Go Back

Installing SQL Server CE Compact Edition

Nick Kleinjan

8/6/2009 1:47:00 PM

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

 

 

 

 

SQL Server Compact

Facebook DZone It! Digg It! StumbleUpon Technorati Del.icio.us NewsVine Reddit Blinklist Furl it!

Comments  9

  • Canda D. 5/16/2011 12:00:00 AM

    Hey I've never really heard of this type of device, and I study servers all the time. I love the idea of having a device in your hand that has server information on it...for two reasons. First, you can rest assured that data is safe, and second, it's handy for sharing server information across many platforms. Soon, I'll be able to sync servers using an app right? Is that what you are telling me? :) Where can I get this app? Until then, I need to continue to run by disaster recovery software in the background!

    Canda, WY

  • Melia 5/21/2011 12:00:00 AM

    AFAICT you've coveerd all the bases with this answer!

  • veutaoycus 5/23/2011 12:00:00 AM

    dbAUTN , [url=http://qwzoiclrlsgj.com/]qwzoiclrlsgj[/url], [link=http://jbudequrqtve.com/]jbudequrqtve[/link], http://rpfqkgngffbx.com/

  • hplyppts 5/31/2011 12:00:00 AM

    3uI1bz , [url=http://kowivxgcomdq.com/]kowivxgcomdq[/url], [link=http://niwisjjfqydu.com/]niwisjjfqydu[/link], http://uxmgcsdsbvtc.com/

  • lv bags 10/13/2011 12:00:00 AM

    Baby Aspen "Big Dreamzzz" Baby Ballerina Replica Mulberry Handbags Two-Piece Layette Set in "Studio" Gift Box, Pink Cheap Mulberry Handbags Made of 100% lusciously soft cotton with an organza tutu trimmed with pink satin ribbonTiny dancer Mulberry Alexa Handbags toes stay warm inside the unique mock-slipper feetNewborn size 0-6 months Mulberry Alexa Replica sleeper comes with a cradle-soft cap with a beribboned topknotLegs have secure snap Mulberry Outlet closure for easy "costume" changes between scenesBox measures 9.25"w x 6"t x 2" d folded, opening to a display size of 9.25"w x 15" t x 2" d with sturdy custom hanger!

  • Canada Goose Parka Jacket 11/24/2011 12:00:00 AM

    both men and women. <a href="http://www.canadageese.us/men-chilliwack-bomber-c-8.html"><strong>Mens Pbi Chilliwack Bomber</strong></a> This is particularly true if we are looking for a specific pair that we have in mind that will go perfectly with our outfit.

    <a href="http://www.cheapuggsnowboot.com/"><strong>Ugg Boots Outlet Sale</strong></a> Formal wear shoes are even harder to find.

  • cheapuggboots 12/31/2011 12:00:00 AM

    pretty well boots

  • cheap oakley sunglasses 1/1/2012 12:00:00 AM

    amazing boots than you imaged 

  • cheap oakley outlet 1/31/2012 12:00:00 AM

    best boots
Post a comment!
  4. Formatting options