Overview of SQL Server Compact

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



What's New in SQL Server Compact 4.0

Describes the new features of SQL Server Compact 4.0 along with previous versions of SQL Server Compact.

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.

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 supported versions of SQL Server.