SQL Server Compact 3.5 SP1 Downloads and Feature Information
- 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.- Edited byErikEJMVP, ModeratorSaturday, May 02, 2009 3:00 PM
- Edited byErikEJMVP, ModeratorMonday, April 06, 2009 2:35 PMSpelling corrected
- Edited byErikEJMVP, ModeratorSaturday, May 02, 2009 2:59 PMAdd hotfix link
-


