Servers

Microsoft SQL Server Compact 4.0

Select Language:
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.
  • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.
    Version:

    4.0.8482.1

    File Name:

    SSCERuntime_x86-ENU.exe

    SSCERuntime_x64-ENU.exe

    Date Published:

    16-01-2012

    File Size:

    2.3 MB

    2.5 MB


      SQL Server Compact 4.0 enables new scenarios and includes a host of new features, including the following:
      • SQL Server Compact 4.0 is the default database for Microsoft WebMatrix, which is a stack of web technologies for easily building and deploying websites on the Windows platform.
      • For enhanced development and debugging capabilities, including designer support, Visual Studio can be used to develop ASP.NET web applications and websites using SQL Server Compact 4.0.
      • Enabled to work in the medium or partial trust environments in the web servers, and can be easily deployed along with the website to the third party website hosting service providers.
      • Private deployment of SQL Server Compact further simplified by having all the required managed assemblies, and the x86 and x64 DLLs, including the Visual C++ 2008 runtime libraries (x86 and x64) SP1 in a single private folder in the install location of SQL Server Compact.
      • 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 like SqlCeConnection.GetSchema that provides the metadata information of the database.
      • Used with ADO.NET Entity Framework, SQL Server Compact now supports the columns that have server generated keys like identity, rowguid etc. and the code-first programming model.

      Support Options:

      Your feedback is important to us.
      • If you have questions about SQL Server Compact, visit the SQL Server Compact MSDN Forum and for more information visit SQL Server Compact blog.

      • Help improve SQL Server Compact by submitting and tracking bugs using Microsoft Connect website. Be sure to select SQL Server Compact as the version and provide detailed repro steps to help us identify the problem.


      For more information on WebMatrix visit the links below:
  • Supported Operating System

    Windows 7, Windows Server 2003 R2 (32-Bit x86), Windows Server 2003 R2 x64 editions, Windows Server 2003 Service Pack 2, Windows Server 2003 Service Pack 2 x64 Edition, Windows Server 2008 R2 SP1, Windows Server 2008 Service Pack 2, Windows Vista Service Pack 2, Windows XP Embedded Service Pack 2 , Windows XP Service Pack 3

      • Microsoft Windows Server 2003 SP2
      • Microsoft Windows Server 2003 R2
      • Microsoft Windows Server 2003 SP2 x64
      • Microsoft Windows Server 2003 R2 x64
      • Microsoft Windows XP Professional Service Pack 3
      • MicrosoftWindows XP Home Service Pack 3
      • Microsoft Windows Vista SP2
      • Microsoft Windows Server 2008 SP2
      • Microsoft Windows Server 2008 R2
      • Windows 7
      Development Computer:
      • For the x86 (32 Bit) installer approximately 23 MB of available hard disk space is required for uncompressing the contents and the setup files

      • For the x64 (64 Bit) installer approximately 37 MB of available hard disk space is required for the same.

      • .NET Framework 3.5 SP1 or .NET Framework 4 needed for managed application development.


    • The files available for download are the x86 (32-bit) and the x64 (64-bit) installers for installing the SQL Server Compact 4.0 on a 32-bit and a 64-bit Computer respectively.

      To download the SQL Server Compact 4.0 x86 installer (SSCERuntime_X86-ENU.exe): (Note that this can be used to install SQL Server Compact on a 32-bit Computer only)
      1. In the Files in this Download section at the bottom of this page, click the SSCERuntime_X86-ENU.exe link.

      2. Do one of the following:
        • To start the installation immediately, click Open or Run this program from its current location
        • To copy the download to your computer for extraction at a later time, click Save or Save this program to disk and specify a location to save the .exe file on your computer. Double-click the .exe file to start the installation.

      To install the SQL Server Compact 4.0 x64 executable (SSCERuntime_X64-ENU.exe): (Note that this can be used to install SQL Server Compact on a 64-bit Computer only)
      1. Do one of the following:
        • To start the installation immediately, click Open or Run this program from its current location
        • To copy the download to your computer for extraction at a later time, click Save or Save this program to disk and specify a location to save the .exe file on your computer. Double-click the .exe file to start the installation.

      To remove this download:
      1. Delete the guide and SSCERuntime-ENU.exe from the folder to which you saved the guide.

      • SQL Server Compact 4.0 is freely redistributable under a redistribution license agreement and application developers redistributing SQL Server Compact 4.0 can optionally register at the SQL Server Compact redistribution site. Registering will help the developers in getting information about SQL Server Compact critical security patches and hot fixes that can be further applied to the client installations.

      • SQL Server Compact 3.5 and SQL Server Compact 4.0 are installed and work side by side on a desktop. The existing installations of SQL Server Compact 3.5 or SQL Server Compact 3.5 SP1 or SQL Server Compact 3.5 SP2 are not upgraded to SQL Server Compact 4.0 when you install SQL Server Compact 4.0 using the installer.

Popular Downloads

Loading your results, please wait...

Free PC updates

  • Security patches
  • Software updates
  • Service packs
  • Hardware drivers

Microsoft suggests

Experience the new and enhanced capabilities.
Try Windows Server 2012 R2
Experience the new and enhanced capabilities.
Free trial