Upgrade your Internet Experience
Microsoft.com
Welcome Sign in
SQL Server Developer Center
Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
 Deploying Smart Device Applications

  Switch on low bandwidth view
Other versions are also available for the following:
SQL Server Compact 3.5 Service Pack 1 Books Online
Deploying Smart Device Applications

This topic describes the two types of application deployment:

  • Deploying your smart device application to one device during development
  • Final application deployment after development is complete

Managed Code Applications

To include Microsoft SQL Server Compact 3.5 (SQL Server Compact 3.5) in a managed Microsoft Visual Studio project, add a reference to the System.Data.SqlServerCe assembly. When this reference is added, three .cab files are automatically deployed to the smart device every time the application is compiled and deployed:

  • Sqlce.dev.language.platform.processor.cab
  • Sqlce.platform.processor.cab
  • Sqlce.repl.platform.processor.cab
    The DLLs are installed in the \Program Files\Microsoft SQL Server Compact Edition\v3.5 directories. For more information about the contents of each .cab file, see Installing and Deploying on a Device (SQL Server Compact).

Native Code Applications

If you are developing an application in Microsoft Visual C++, SQL Server Compact 3.5 is not automatically installed when you deploy your application. You must first copy the SQL Server Compact 3.5 installation .cab file and install it on the smart device. The .cab file for SQL Server Compact 3.5 is named Sqlce.platform.processor.cab and is located in the following directory:

%Program Files%\Microsoft SQL Server Compact Edition\v3.5\Devices\platform\processor

ms173409.note(en-us,SQL.100).gifNote:
If your application uses merge replication or RDA, you must also install the Sqlce.repl.platform.processor.cab file.

When your application is complete, and you are ready to deploy it to multiple devices, you create a .cab file for the application, and then use this .cab file to install the application to multiple devices. To create a .cab file for your application in Visual Studio, on the Build menu for your project, select Build CAB File.

The resulting .cab file contains only the binaries for your application. It does not include SQL Server Compact 3.5 or the Microsoft .NET Compact Framework. To fully deploy your application, you must copy and extract the SQL Server Compact 3.5 and .NET Compact Framework .cab files together with your application .cab file.

  • The .NET Compact Framework .cab file is named NETCFversion.platform.processor.cab. It is in the following directory:
    \Program Files\Microsoft.NET\SDK\CompactFramework\NETCFversion\WindowsCE\platform\processor\NETCFversion.platform.processor.cab.
  • The .cab files for SQL Server Compact 3.5 are named Sqlce.platform.processor.cab and Sqlce.repl.platform.processor.cab. They are in the following directory:
    %Program Files%\Microsoft SQL Server Compact Edition\v3.5\Devices\platform\processor

For example, to include version 2.0 of the .NET Compact Framework and SQL Server Compact 3.5 in your deployment of an application you have developed for the Windows CE 5 operating system on an armv4 processor, you must include the following two files:

  • C:\Program Files\Microsoft.NET\SDK\CompactFramework\v2.0\WindowsCE\wce500\armv4i \NETCFv2.wce5.armv4.cab
  • C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Devices\wce500\armv4i\sqlce.wce5.armv4i.cab
ms173409.note(en-us,SQL.100).gifNote:
If your application uses merge replication or RDA, you must also install the Sqlce.repl.platform.processor.cab file.

© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker