Installing and Deploying on a Device (SQL Server Compact Edition)
Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) is installed automatically on the smart device when deploying a managed application created in Microsoft Visual Studio 2005. If you create a native application in Visual Studio 2005 by using Visual C++ , you must manually copy the files that install SQL Server Compact Edition on a smart device.
Installing SQL Server Compact Edition When Deploying a Managed Application
When you build a managed application that references the System.Data.SqlServerCe namespace, and the application is deployed to a smart device or the Pocket PC emulator, Visual Studio automatically checks to see whether the device has the Microsoft .NET Compact Framework and SQL Server Compact Edition client components installed. If these components are not detected, they are automatically installed on the device the first time that you deploy an application that references the System.Data.SqlServerCe namespace.
To deploy an application to a smart device, click Start on the Debug menu in Visual Studio. Then, choose whether to deploy to a connected smart device or to the Pocket PC emulator. The default installation location on the device is \Windows.
Installing SQL Server Compact Edition When Deploying a Native Application
SQL Server Compact Edition and SQL Server Compact Edition Query Analyzer are installed automatically if you are using Visual Studio 2005 with a smart device project. They require manual installation if you are developing a native application by using Visual C++.
You must manually copy SQL Server Compact Edition and SQL Server Compact Edition Query Analyzer to the device by copying and extracting the following .cab files from \Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\platform\processor to the root directory of the device: sqlce30.platform.processor.cab and sqlce30.dev.language.platform.processor.cab. If your application uses merge replication or remote data access, you also must install sqlce30.repl.platform.processor.cab. A shortcut to SQL Server Compact Edition Query Analyzer appears on the Start menu of the device.
To start SQL Server Compact Edition Query Analyzer, either click the application name on the Start menu or tap the icon on the device.