Saturday, February 27, 2010

New KB article about how to remove SQL Compact 3.5 SP1

MS has published a KB article about how to remove SQL Compact from a machine with SQL Server 2008 installed (which automatically installs SQL Compact 3.5 SP1 and corresponding Server Tools). Why would anyone want to do this ;-) ?

Tuesday, February 23, 2010

SQL Compact versions on Windows Mobile

Since version 6 of Windows Mobile, every version of Windows Mobile (6, 6.1, 6.1.4, 6.5 and 6.5.3) have included SQL Server Compact Edition version 3.1. But each OS version has contained a newer build of 3.1. The desktop RTM version of SQL Compact was 3.0.5300.0.

The table below summarizes the various OS version and the corresponding SQL Compact build number:


Windows Mobile version SQL Compact build
6.0 3.0.5258.0
6.1 3.0.5258.0
6.1.4 3.0.5258.0
6.5 3.0.5300.8
6.5.3 3.0.5300.16

Look here for a list of hotfixes and corresponding build numbers.