SQL Server Compact 3.5 SP1 Downloads and Feature Information

Question

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.