This documentation is archived and is not being maintained.

How to: Install SQL Server Compact Edition on a Device

If you use Microsoft Visual Studio to build a .NET application that uses Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition), the first time that you deploy the application to a device, the SQL Server Compact Edition engine is automatically installed on the device. You can also install SQL Server Compact Edition to a device by manually copying the .cab files to the device. If you are building a native application, you must manually copy the .cab files.

  1. Install the .NET Compact Framework on the device. Copy the NETCFv2.<platform>.<processor>.cab file to your device from the following directory:

    C:\Program Files\Microsoft Visual Studio 8\ SmartDevices\SDK\CompactFramework\2.0\v2.0\WindowsCE \<platform>\<processor>\

  2. On the device, click the .cab file to install the .NET Compact Framework.

  3. Copy the and files to your device from the following directory:

    C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\<platform>\<processor>\

You only need to install if your application uses merge replication or remote data access.