Architecture (SQL Server Compact Edition)

Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) architecture includes both a development environment and a client and server environment. This section describes the components that make up each environment.

SQL Server Compact Edition architecture

Development Environment

The development environment includes the computer on which applications are developed. This computer must have Microsoft Visual Studio 2005, including the .NET Compact Framework, to create applications for SQL Server Compact Edition. You can create managed applications by using either Microsoft Visual Basic or C#, or you can use Microsoft Visual C++, previously referred to as Microsoft eMbedded Visual C++ 4.0, to create native applications .

For more information about the development environment, see Installing a Development Environment.

Client and Server Environment

In the SQL Server Compact Edition architecture, the client environment is made up of one or more supported devices on which the application and SQL Server Compact Edition are deployed. When the devices do not contain network connectivity, you can use Microsoft ActiveSync to connect SQL Server Compact Edition to the server environment.

The server environment is made up of one or more computers that run Microsoft Internet Information Services (IIS) and an instance of Microsoft SQL Server or data propagated for a heterogeneous data source. You can run IIS and SQL Server on the same computer or configure them over multiple computers. IIS is required to connect to and exchange data between servers and clients.

In This Section

Topic Description

Development Environment

Provides more details about the SQL Server Compact Edition development environment.

Client and Server Environment

Provides more details about the SQL Server Compact Edition client and server environment.