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.

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.