Architecture (SQL Server Compact)

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

Development Environment

The development environment includes the computer on which applications are developed. This computer must have Microsoft Visual Studio 2008 to create applications for SQL Server Compact 3.5. You can create managed applications by using either Microsoft Visual Basic or C#, or you can use Microsoft Visual C++ 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 3.5 architecture, the client environment is made up of one or more supported devices on which the application and SQL Server Compact 3.5 are deployed. When the devices do not contain network connectivity, you can use Microsoft ActiveSync to connect SQL Server Compact 3.5 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 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 3.5 development environment.
Client and Server Environment	Provides more details about the SQL Server Compact 3.5 client and server environment.