Export (0) Print
Expand All

SQL Server CE Environment

SQL Server 2000

Microsoft® SQL Server™ 2000 Windows® CE Edition (SQL Server CE) provides a compact database solution for mobile and embedded devices. By using Microsoft Visual Studio® .NET or Microsoft eMbedded Visual Tools, you can extend the enterprise data management capabilities of SQL Server to Windows CE-based devices. The following illustration shows the relationship of three typical environments in which SQL Server CE can be used.

Illustration showing the relationship of the three environments in which SQL Server CE can be used: a development, a client, and a server environment.

Development Environment

This is the computer on which Windows CE-based applications are developed. This computer must have one of the following development environments:

  • Microsoft Visual Studio .NET
  • Microsoft eMbedded Visual Tools version 3.0 installed with at least one of the following software development kits (SDKs): Handheld PC 2000 SDK, Pocket PC SDK, or the Windows Powered Pocket PC 2002 SDK.
Client Environment

This is the device on which the Windows CE-based application is deployed. When the Windows CE-based device does not contain network connectivity, Microsoft ActiveSync® can be used to connect to the server environment.

Server Environment

This is the computer(s) that runs Microsoft Internet Information Services (IIS) and an instance of Microsoft SQL Server. You can run IIS and SQL Server on the same computer or configure them over several computers. Remote data access (RDA) and merge replication communicate with SQL Server through IIS.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft