SQL Server Compact Books Online Home Page

Microsoft SQL Server Compact 4.0 has a group of new features, including a new scenario where SQL Server Compact 4.0 can be used as a database for ASP.NET Web applications and Web sites. SQL Server Compact 4.0 provides an easy and simple to use database storage for starter Web sites and is a free, easy-to-use, lightweight, and embeddable version of SQL Server 2008 R2. 

With SQL Server Compact 4.0, you can develop both desktop and Web applications in Visual Studio. SQL Server Compact 4.0 is also integrated with the Microsoft Webmatrix, which is a stack of Web technologies for easily developing and deploying Web sites on the Windows platform.

For more information, see What's New in SQL Server Compact 4.0.

For a list of Windows platforms supported by SQL Server Compact 4.0, see Hardware and Software Requirements.

To learn more

SQL Server Compact Concepts Provides conceptual information about SQL Server Compact that includes Getting Started and Overview information, SQL Server Compact concepts, task-based How-to topics and tutorials, and troubleshooting information. Development (SQL Server Compact) Provides information about how to build and deploy SQL Server Compact and samples. Technical Reference (SQL Server Compact) Provides information about user interface reference (F1 help), managed and native programming references, SQL grammar reference, and the System.Data.SqlServerCe namespace, the managed data provider for SQL Server Compact.

General Information Installing SQL Server Compact Overview of SQL Server Compact Getting Started with Books Online (SQL Server Compact) Additional Information SQL Server Compact 4.0 Product Download SQL Server on Microsoft.com SQL Server on TechNet SQL Server Developer Center Data Access and Storage Developer Center XML Developer Center SQL Server 2005 Books Online Download Center SQL Server 2008 Books Online Download Center