Servers

Microsoft SQL Server Compact 3.5 and Microsoft Synchronization Services for ADO.Net v1.0 for Windows Desktop

Select Language:
SQL Server Compact 3.5 is a small footprint in-process database engine that allows developers to build robust applications for Windows Desktops and Mobile Devices. This download contains the files for SQL Server Compact 3.5 and Synchronization Services for ADO.Net v1.0 for Windows Desktop platform
  • Version:

    3.5.5386.0

    File Name:

    SSCERuntime-ENU.msi

    Date Published:

    25-11-2007

    File Size:

    1.7 MB

      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
  • Supported Operating System

    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 2, Windows Server 2003, Datacenter Edition (32-bit x86), Windows Server 2003, Enterprise Edition (32-bit x86), Windows Server 2003, Standard Edition (32-bit x86), Windows Vista Business, Windows Vista Enterprise, Windows Vista Home Basic, Windows Vista Home Premium, Windows Vista Starter, Windows Vista Ultimate, Windows XP Embedded Service Pack 2 , Windows XP Home Edition , Windows XP Media Center Edition, Windows XP Professional Edition, Windows XP Service Pack 2, Windows XP Tablet PC Edition

      • 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



      Development Computer
      • 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.
      • SQL Server Compact 3.5 is freely redistributable under a redistribution license agreement that requires registration. Independent software vendor (ISV) or solution integrator (SI) shipping applications using SQL Server Compact 3.5 must register for redistribution rights. Registering will help the ISV/ SI in getting information about SQL Server Compact critical security patches and hot fixes. The SQL Server Compact critical security patches and hot fixes have to be applied to the client installations by the ISV/ SI. For more information visit the registration page for SQL Server Compact 3.5 redistribution rights
      • Prior to installing the released version of SQL Server Compact 3.5, uninstall all earlier versions of SQL Server Compact 3.5 CTP and Beta and Microsoft Synchronization Services for ADO.NET CTP and Beta by using the Add/Remove Programs in the Control Panel

      • Microsoft Visual Studio 2008 installs SQL Server Compact 3.5 and Synchronization Services for ADO.Net by default. If you have already installed Visual Studio 2008 than you don't need to separately download and install SQL Server Compact 3.5

      • The package installs SQL Server Compact 3.5 in %Program Files%\Microsoft SQL Server Compact Edition\v3.5 folder and Microsoft Synchronization Services for ADO.NET in the %Program Files%\Microsoft Synchronization Services\ADO.NET\v1.0 folder

      • For replicating data between SQL Server Compact 3.5 or SQL Server 2005 Compact Edition and SQL Server 2005 (or later versions of SQL Server 2005) install SQL Server Compact 3.5 Server Tools on the IIS server

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