SQL Server CE Environment
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.
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.
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.
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.