How to: Install Query Analyzer (SQL Server Compact Edition)

  • Article

If you use Microsoft Visual Studio to build a .NET application that uses Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition), and you deploy the application in debug mode, the SQL Server Compact Edition engine and Query Analyzer are automatically installed on the device. You can also install the Query Analyzer by copying the .cab file to the device. If you are building a native application, you must manually copy the .cab file.

Note

SQL Server Compact Edition Query Analyzer is not available with Smart Phone 2005.

To manually install the Query Analyzer

  1. Install the .NET Compact Framework on the device. Copy the following file to your device:

    \Program Files\Microsoft Visual Studio 8\SDK\version\CompactFramework\WindowsCE\platform\processor\NETCFversion.platform.processor.cab.

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

  3. Copy the sqlce30.dev.ENU.<platform>.<processor>.cab file to your device from the following directory:

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

  4. On the device, click the .cab file to install the Query Analyzer.

  5. A shortcut to Query Analyzer is added to the Start menu of the device.

See Also

Tasks

How to: Install SQL Server Compact Edition on a Device

Concepts

Installing and Deploying on a Device (SQL Server Compact Edition)

Other Resources

Installing SQL Server Compact Edition

Help and Information

Getting SQL Server Compact Edition Assistance