SQL Compact 3.5 SP1 RTM

As SQL Server 2008 has just been released, SQL Compact 3.5 SP1 is now also released. Go get it:
http://msdn.microsoft.com/subscriptions/downloads/default.aspx
http://technet.microsoft.com/subscriptions/downloads/default.aspx

UPDATE: Steve Lasker has more detailed information on his blog, with direct links to the downloads, including 64 bit (x64) downloads.

Merge Replication and ISA Server

There is very limited, if no, information available regrading setting up Merge Replication with and ISA Server in the middle. This has now been remedied by this excellent post, from Breeze Training.

Sync Framework V1 released

MS Sync Framework, which is also the basis of ADO.NET Sync Services V2 has been released. This blog post has links to the download and other relevant information. Part of the technology used for Sync Framework is of course SQL Compact 3.5.

Intro to Mobile Sync

Christopher Fairbairn has posted a good overview of SQL Compact, and the related synchronization technologies.

News from blog land

A collection of new blog entries relatied to SQL Compact:

Tim Anderson is faced with the classical problem of not knowing where the database and the data resides when using the graphical designers.

On the SQL Compact Blog, there is information about the causes of database file corruption. Most issuse appear to be related to SD Card issues.

Also on the SQL Compact Blog, there is documentetion about Merge Replication support for the new datatypes in SQL Server 2008 (data and spatial types).

Laxmi from the product team blogs about details of the 3.5 SP1 features, in particular Case Sensitivity and 64 bit support.

Finally, the Sync Framework team has published advance documentation on implementing 2-way Sync by extending the VS 2008 SP1 Sync Designer generated code.

Windows Mobile platform support

SQL Compact is now being included in various versions of Windows Mobile. It can be difficult to determine which Windows Mobile version contains which version of SQL Compact. There is an overview available here. The overview also contains information about EDB/CEDB, and overview over platforms supported by the development tools.

SQL Compact 3.5 SP1 news

SQL Compact 3.5 SP1 will contain quite a number of new features. This Service Pack will be released together with Visual Studio 2008 SP1/.NET Framework 3.5 SP1.

The release of SQL Compact 3.5 SP1 will contain the following new features on top of a number of bug fixes:

1. Support for x64 both on the runtime and server tools. (Will be made available as a web download when VS 2008 SP1 is released. Steve Lasker blogs in detail about the support for this new platform.
2. Support for Entity Framework and Entity SQL. Ravi Tandon has more info on the SQL Compact blog. This support is for desktop only - not devices.
3. Support for "Local Database Cache" for device projects (currently available as a CTP). This means that Microsoft Synchronization Services for ADO.NET is now available for devices.
4. The Server Tools (for Merge and RDA) will fully support SQL Server 2008.

UPDATE 15/5 2007: The SP1 beta is now available for download, and Steve Lasker has more details about the SP1 changes and features.