Sign in

    Microsoft SQL Server 2005 Compact Edition

    Select Language:
    Microsoft SQL Server 2005 Compact Edition is the compact database for rapidly developing applications in both native and managed environment that extend enterprise data management capabilities to desktop applications
    • Version:


      File Name:


      Date Published:


      File Size:

      1.7 MB

      KB Articles: KB920700

        Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) is designed for developers who need light weight, in process relational database solution for their applications that can be developed and deployed on desktop as well as on mobile devices. SQL Server Compact Edition Runtime can be used to develop and deploy applications on desktop.

        SQL Server Compact Edition is a powerful, yet lightweight relational database engine that makes it easy to develop desktop applications by supporting familiar Structured Query Language (SQL) syntax and providing a development model and API consistent with SQL Server. When compared to its previous release, SQL Server Mobile, SQL Server Compact Edition includes new features like |DataDirectory| and ClickOnce support for ease of deployment (Please see SQL Server Compact Edition Readme)

        To install the localized version of SQL Server 2005 Compact Edition (SQLServerCE31-[LN].msi), you must install the English version (SQLServerCE31-EN.msi) first, and then install the localized version. Note that [LN] represents the localized language.

        For more information please see the SQL Server Compact Edition Books Online
    • Supported Operating System

      Windows 2000 Professional Edition , Windows 2000 Service Pack 4, Windows Server 2003 R2 Datacenter Edition (32-Bit x86), Windows Server 2003 R2 Enterprise Edition (32-Bit x86), Windows Server 2003 R2 Standard Edition (32-bit x86), Windows Server 2003 Service Pack 1, Windows Vista, Windows XP Home Edition , Windows XP Media Center Edition, Windows XP Service Pack 2, Windows XP Tablet PC Edition

        Development Computer

        • 2 MB of available hard disk space. (An additional 2 MB of space must be also available for temporary setup files.)

        For Merge replication and remote data access (RDA) support for desktop to desktop sync.

        • SQL Server 2000 SP3a or higher

        • IIS 5.0 or later versions: Supported on Windows Server 2003, Windows 2000 SP4 or later versions, and Windows XP; 120 MB of available disk space on the server
    • Install Instructions
        1. Click the Download button on this page to start the download, or choose a different language from the drop-down list and click Go.
        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 installation at a later time, click Save or Save this program to disk.
      • SQL Server 2005 Compact Edition includes a Microsoft Windows Installer (.msi) file. The .msi file installs redistributable components to a specific location on the destination computer. To ensure serviceability and technical support, use the .msi file to deliver software components. Please see Redist.txt included in the package for component information.

        SQL Server 2005 Compact Edition can be installed by running the installer - SQLServerCE31-EN.msi. Installing SQL Server 2005 Compact Edition by running SQLServerCE31-EN.msi installs the provider (System.Data.SqlServerCe.dll) in the GAC (global assembly cache) and registers the OLEDB provider (sqlceoledb30.dll). Doing this ensures that the components can be serviced in future by Microsoft Update. Administrator privileges are required on the machine for installing SQL Server 2005 Compact Edition. Independent Software Vendors and application developers redistributing SQL Server 2005 Compact Edition components or DLL’s as part of their application will need to take care of the serviceability of SQL Server 2005 Compact Edition components. Microsoft Update can only service SQL Server 2005 Compact Edition components that are deployed by using the installer - SQLServerCE31-EN.msi.
    • Related Resources