All SQL Compact 3.5 SP1 downloads now available

With the current release of Sync Services for Devices, all the SQL Compact 3.5 SP1 downloads are now available here.

Sync Services for Devices released to web

The Sync Services for devices runtime has now been released to web, including an updated sample application. Sync Services requires SQL Compact 3.5 SP1 to be installed on the device. There have been some issues with performance during sync, that have not yet been solved properly, so beware. (RDA and Merge has proprietary support for compression). I have updated my SQL Compact feature matrix accordingly.

SQL Compact and LINQ to SQL performance advise

Technorati Tags: SQL Compact,SQL Server Compact Edition

Matt Manela has posted some good advice on how to avoid a performance penalty when using SQL Compact with LINQ to SQL. SQL Compact works best if there is a initial open connection to the database file available for the lifetime of the application, and Matt's code implements this concept.

SQL Server 2008 Management Studio Express released

As part of the release of SQL Server 2008 Express, SQL Server 2008 Management Studio Express (which can be used for managing and query analyzing SQL Compact 3.5 databases), is now available for download as part of SQL Server Express with Tools. Finally, 9 months after the release of VS 2008 (which included SQL Compact 3.5)

Export SQL Compact 3.5 data and schema

Bembeng Arifin has created this excellent command line utility, which creates a .sql script for migrating SQL Compact 3.5 data to SQL Server (includes CREATE and INSERT statements). Highly recommended - source code also available.

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.