Microsoft SQL Server Compact 4.0

Microsoft SQL Server Compact 4.0 is a free, embedded database that software developers can use for building ASP.NET websites and Windows desktop applications. SQL Server Compact 4.0 has a small footprint and supports private deployment of its binaries within the application folder, easy application development in Visual Studio and WebMatrix, and seamless migration of schema and data to SQL Server.

Project Details:

Everything you need to build Web sites using Windows

Microsoft WebMatrix is a new Web development tool that includes IIS Express (a development Web server), ASP.NET (a Web framework), and SQL Server Compact (an embedded database).

WebMatrix makes Web site development easy

Start coding, testing, and deploying your own Web sites without having to worry about configuring your own Web server, managing databases, or learning a lot of concepts.

Start from scratch using HTML, CSS, and JavaScript

Start with your own HTML, CSS, and JavaScript and then connect to a database or add dynamic server code using the new inline syntax for ASP.NET Web pages. Code, run, and publish your Web site, all using WebMatrix.

Start with popular PHP or ASP.NET Web apps

Free and popular open-source Web applications such as WordPress, Joomla!, DotNetNuke or Umbraco are just a click away. Simply select an application, and WebMatrix handles downloading, installing, and configuring it for you. Customize your site using the built-in code-editor and make it yours.

Seamless site publishing and hosting

With WebMatrix you can find the perfect home for your Web site. Use WebMatrix to find a Web host that fits your requirements and use the built-in publishing support for FTP, FTPS, and WebDeploy to ensure that your files, databases, and settings arrive intact on the Web.

  • Free to use and distribute.
  • Support for web, desktop, and mobile devices.
  • Small footprint for easy deployment.
  • Fully embeddable architecture.
  • No administration.
  • Single file, code-free database format.
  • Support for nonadmin, embedded installations.
  • Support for a subset of syntax and data types.
  • Integration with Microsoft Visual Studio.
  • Support for various programming languages.