How to: Install SQL Server Compact on a Device

If you use Microsoft Visual Studio to build a .NET-connected application that uses Microsoft SQL Server Compact 3.5 (SQL Server Compact 3.5), the first time that you deploy the application to a device, the SQL Server Compact 3.5 engine is automatically installed on the device. You can also install SQL Server Compact 3.5 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.

To manually install SQL Server Compact 3.5 on a device

  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.

  4. On the device, click each .cab file to install the .dll files.

See Also


How to: Install Query Analyzer (SQL Server Compact)


Installing and Deploying on a Device (SQL Server Compact)

Other Resources

Installing SQL Server Compact

Help and Information

Getting Assistance (SQL Server Compact 3.5 Service Pack 1)