Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

SQL Server Compact 3.5 includes a host of new features including the following:

• LINQ to SQL enabling developers to integrate data access directly into their code
  
• Side-by-side installation together with SQL Server 2005 Compact Edition (version 3.1)
  
• Support for newer and more secure encryption algorithms
  
• Additional timestamp (rowversion) data type


• Enhanced support for Transact-SQL statements including:
  
  • Nested query in FROM clause
    
  • CROSS APPLY and OUTER APPLY
    
  • CAST and DECIMAL
    
  • SET IDENTITY INSERT
    
  • TOP
• Synchronization Services for ADO.NET providing the ability to synchronize data from disparate sources over two-tier, N-tier, and service-based architectures
  
• Support for System.Transactions
  
  

For more information please see the SQL Server Compact 3.5 Books Online and the Synchronization Services for ADO.Net Books Online

Post feedback and questions to SQL Server Compact 3.5 MSDN Forum and Synchronization Services for ADO.Net MSDN Forum

For tips and tricks visit Steve Lasker blog, Synchronization Services for ADO.Net blog and SQL Server Compact blog

Support Options:
Your feedback is important to us.

• If you have questions about SQL Server Compact, visit the SQL Server Compact MSDN Forum


• 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


• Contact Microsoft Professional Support. For deeper support needs, purchase a Professional Support package and have experts available 24 hours a day, seven days a week, and 365 days a year


• Find out what support options are available if you are located outside the United States or Canada at Worldwide Support Options


• Search the Knowledge Base Articles. Get the answers you need about SQL Server Compact from the Microsoft Knowledge Base. This is the same database of technical articles used by Microsoft Support Professionals


• To participate in the future SQL Server Compact Technology Adoption Program (TAP), please send us an email

Files

Status: Deleted This download is no longer available on microsoft.com. The downloads below are archives provided by the Internet Archive Wayback Machine from the Microsoft Download Center prior to January 2019.

Files
SSCERuntime-ENU.msi SHA1: 16931ae7df18ab967e4bd0815ccd89a3dc429547 Size: 1.14 MB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

• 32-bit version of SQL Server Compact is supported under WOW64 mode until a native 64-bit release for SQL Server Compact is available


• For the Windows Mobile platform, please see the SQL Server Compact 3.5 for Windows Mobile download page

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


• Visual Studio 2008

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.