Share via


Installing SQL Server Compact

Microsoft SQL Server Compact is a relational database with a compact footprint that is ideal for embedding in device and desktop applications. SQL Server Compact supports the same SQL syntax and ADO.NET programming model as other editions of SQL Server. The management tools for SQL Server Compact are SQL Server Management Studio, SQL Server Management Studio Express, and Visual Studio Server Explorer. The development environment is Visual Studio 2008 or later versions.

SQL Server Compact can also be used as a stand-alone database for personal information management (PIM) tools or other applications on the supported devices and desktop computers. SQL Server Compact is free to download, deploy and distribute.

Important

A SQL Server Client Access License (CAL) is required for any connection to SQL Server, including a connection from SQL Server Compact.

SQL Server Compact is available in three ways:

  • Integrated with SQL Server 2008 or later versions.
  • Integrated with Microsoft Visual Studio 2008 or later versions.
  • As a download from the Microsoft SQL Server Compact 3.5 Web site
    This section describes how to install SQL Server Compact and its various components.
Topic Description

Hardware and Software Requirements

Lists hardware and software requirements for each system that is used with SQL Server Compact.

Installing Prerequisite Software

Describes the prerequisite software and describes how to install and configure the software that is used with SQL Server Compact.

Installing a Development Environment

Describes the software that must be installed to form a development environment.

Installing a Server Environment

Describes the different types of SQL Server Compact server environments and the software that is required to exchange data with SQL Server.

Installing and Deploying on a Device (SQL Server Compact)

Describes how to install SQL Server Compact on a device.

Installing and Deploying on a Device (SQL Server Compact)

Describes how to install SQL Server Compact on a desktop.

Upgrading from Earlier Versions (SQL Server Compact)

Provides information about upgrading from earlier versions of SQL Server Compact.