Overview of SQL Server Compact

  • Article

Microsoft SQL Server Compact 3.5 is a compact database ideal for embedding in mobile and desktop applications. SQL Server Compact 3.5 gives developers a common programming model with other SQL Server editions for developing both native and managed applications. SQL Server Compact 3.5 provides relational database functionality in a small footprint: a robust data store, an optimizing query processor, and reliable, scalable connectivity.

Topic Description

What's New in SQL Server Compact 3.5 and 3.5 SP1

Describes the new features of SQL Server Compact 3.5 and SQL Server Compact 3.5 Service Pack 1 (SP1).

Features (SQL Server Compact)

Explains SQL Server Compact features.

Working with SQL Server Compact

Lists the steps to set up a SQL Server Compact environment.

Architecture (SQL Server Compact)

Provides an overview of the SQL Server Compact architecture.

Side-by-Side Support for SQL Server Compact Versions

Explains side-by-side support of SQL Server Compact with earlier versions.

Differences Between SQL Server Compact and SQL Server

Lists Transact-SQL commands, features, and data types supported by SQL Server Compact, compared with SQL Server 2005.