Saturday, August 23, 2008

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)

Saturday, August 9, 2008

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.

Thursday, August 7, 2008

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.

Wednesday, August 6, 2008

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.

Tuesday, August 5, 2008

Intro to Mobile Sync

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