Rapidly build and deploy applications with SQL Server Compact, the embedded database engine. Use Visual Studio 2010 SP1 and WebMatrix to build and deploy standalone and ASP.NET web applications.
Compact is the default database for WebMatrix, a web development tool that includes everything you need for website development.
For enhanced development and debugging capabilities, Visual Studio can be used to develop ASP.NET web apps and websites.
Compact can be easily deployed along with the website to third party website hosting service providers.
Private deployment simplified by having all the required managed assemblies and DLLs in a single private folder in the install location.
Stronger data security with the use of the SHA2 encryption algorithms for encrypting the databases.
T-SQL syntax enhancement by adding support for OFFSET and FETCH that can be used to write paging queries and new APIs.
WebMatrix is a free web development tool from Microsoft that includes everything you need for website development. Start from open source web applications, built-in web templates or just start writing code yourself. It’s all-inclusive, simple and best of all free. Developing websites has never been easier.
SQL Server Compact 4.0 is the next generation of embedded database from the SQL Server family, and brings all of its goodness to the world of ASP.NET web application development.
Take advantage of integrations with Visual Studio 2010 SP1 and WebMatrix, including rich table and query designers; write, execute, and test queries with visual query plans; full integration with Server Explorer; drag-and-drop IDE support; and ClickOnce for client deployment; and web deploy for deploying websites to third party website service hosting providers.
SQL Server 2012 editions are now offered in a consistent, tiered model which creates greater consistency across editions, features, and licensing.
Join the SQL Server Community to access resources, connect with peers, and learn from Microsoft experts.
Find out more about the range of Microsoft products and technologies that work with SQL Server.
Download previous versions of SQL Server Compact embedded database.
Download SQL Server Compact documentation to learn how to build applications for Windows Desktops and Mobile Devices.
SQL Server Compact 3.5 SP2 Server Tools Windows Installer (MSI) file installs replication components on the computer running IIS for synchronizing data with SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.