Share via


SQL Server Compact 3.5 SP1 Downloads and Feature Information

Question

Monday, April 6, 2009 2:34 PM

The most recent SQL Compact installation files are included with SQL Server 2008 and Visual Studio 2008 SP1 (32 bit desktop binaries only).

All downloads are available from here: http://www.microsoft.com/sqlserver/2005/en/us/compact-downloads.aspx

Post 3.5 SP1 hotfixes are listed here: http://erikej.blogspot.com/2009/05/sql-compact-35-sp1-downloadable-hotfix.html

Information about the new features and fixes you can find here: http://support.microsoft.com/kb/955965/en-us

Additional information can be found here: http://blogs.msdn.com/laxmi/archive/2008/06/26/sql-ce-v3-5-sp1-features.aspx 

Detailed information about x64 support here: http://blogs.msdn.com/stevelasker/archive/2008/05/13/sql-server-compact-3-5-64bit-coming-soon.aspx

More details about case sensitive databases here: http://erikej.blogspot.com/2008/07/working-with-case-sensitive-sql-compact.html and here: http://msdn.microsoft.com/en-us/library/cc835498.aspx

There is a walkthrough of Entity Framework support here: http://blogs.msdn.com/sqlservercompact/archive/2008/03/07/my-first-entity-application-against-sqlce.aspx

The new features and enhancements in 3.5 SP1 include the following:

  • Support for ADO.NET Entity Framework

  • Case-sensitive collations at the database level

  • Runs natively in the 64-bit environment

  • Improved support for private deployment of 32-bit and 64-bit applications

  • Replication of the new data types in SQL Server 2008 such as Date, Time, DateTime2, DateTimeOffset, Geography, and Geometry to SQL Server Compact. The new data types in SQL Server 2008 are supported through mapped data types such as nchar, nvarchar, image, etc. in SQL Server Compact

  • Enhanced version compatibility between SQL Server Compact and SQL Server 2008 for merge replication, including support for SQL Server 2005 publications

  • Support for Synchronization Services for ADO.NET version 1.0 Service Pack 1 that include the following new features:

    • Synchronization of data between SQL Server Compact 3.5 on mobile devices or desktop with SQL Server and any other ADO.NET Data Provider

    • Support for SQL Server 2008 change tracking

    • Replication of the new data types in SQL Server 2008

    • Tracing of the synchronization process to easily troubleshoot issues


Erik Ejlskov Jensen, MCTS: WM App, MCITP: SQL 2008 Dev - http://erikej.blogspot.com Please mark as answer, if this was it.

All replies (5)

Tuesday, April 26, 2011 7:55 PM

Hi Erik,

Please confirm if replication components  for SSCE 3.5 SP1+ can be deployed privately. There are some confusing remarks in the BOL for SSCE 3.5 about that:

ms-help://MS.SSC.v35/MS.SSC.v35.EN/sscmain/html/72bc88df-32c3-4040-9397-0dbf86f2c106.htm

QUOTE

Important:
To replicate data between SQL Server and SQL Server Compact, you must install replication components. For more information about SQL Server replication components, see Hardware and Software Requirements. You must also install the server tools (SSCEServerTools-ENU.msi). For more information about the server tools, see Connectivity Tools.

UNQUOTE

Thanks!

Everything is possible


Wednesday, April 27, 2011 8:28 AM

No, they must be installed by an administrator (it is a ISAPI dll)Please mark as answer, if this was it. Visit my SQL Server Compact blog


Wednesday, April 27, 2011 11:11 AM

Hi Erik,

To make sure we are on the same page: ISAPI is for server installations, right? My question was about deployment on computer with merge replication subscriber.

Waiting for yours.

Thank you!

Everything is possible


Wednesday, April 27, 2011 11:20 AM | 1 vote

Sorry, the client replication components can of course be deployed privately, it is sqlceca35.dllPlease mark as answer, if this was it. Visit my SQL Server Compact blog


Wednesday, April 27, 2011 11:47 AM

That's great, thanks!

P.S.

I hope MS documentation can become more understandable one day :)

Everything is possible