SQL Server Compact Release Versions


 


This blog post is meant to give different build version numbers of our SQL Server Compact Releases. This blog post is a living one and gets updated for every release we make.


 


Before getting into the mapping, first you want to know the version you are having.  There are multiple means: 


Registry: HKLM\Software\Microsoft\Microsoft SQL Server Compact Edition\*\DesktopRuntimeVersion


File Properties: Check file properties of some SQL CE DLL and check for “File version” the first line of version tab


 





























































































Product Name


Release Vehicle


Version


SQL Server 2005 Mobile Edition


Visual Studio 2005 RTM


3.0.5206


SQL Server 2005 Mobile Edition


SQL Server 2005 RTM


3.0.5207


SQL Server 2005 Compact Edition


Visual Studio 2005 SP1


3.0.5300


SQL Server 2005 Compact Edition


SQL Server 2005 SP2


3.0.5300


SQL Server 2005 Compact Edition


Download Center


3.0.5300


SQL Server 2005 Compact Edition


Windows Mobile 6.0


3.0.5289


SQL Server Compact 3.5 Beta1


Visual Studio 2008 Beta1


3.5.5339


SQL Server Compact 3.5 Beta2


Visual Studio 2008 Beta2


3.5.5365


SQL Server Compact 3.5 RTM


Visual Studio 2008 RTM


3.5.5386


SQL Server Compact 3.5 RTM


Download Center


3.5.5386


SQL Server Compact 3.5 SP1 Beta


SQL Server 2008 CTP5 OR


SQL Server 2008 Nov07 CTP


3.5.5608


SQL Server Compact 3.5 SP1 Beta for ADO.NET Entity Framework Provider Beta


Download Center


3.5.5626


SQL Server Compact 3.5 SP1 Beta


SQL Server 2008 CTP6 OR


SQL Server 2008 Feb08 CTP


3.5.5626


SQL Server Compact 3.5 SP1 RTM


Visual Studio 2008 SP1 RTM

3.5.5692

SQL Server Compact 3.5 SP1 RTM


SQL Server 2008 RTM


3.5.5692


SQL Server Compact 3.5 SP1 RTM 


with .NET Framework 4 Beta Support


Visual Studio 2010 Beta 1 


3.5.5802 


SQL Server Compact 3.5 SP2 Beta 


Microsoft Visual Studio 2010 and .NET Framework 4 Beta 2


3.5.8044 


SQL Server Compact 3.5 SP2 Beta 


SQL Server Compact 3.5 SP2 Beta for Windows Desktop Web Download


3.5.8049 


SQL Server Compact 3.5 SP2 Release Candidate


Visual Studio 2010 and .NET Framework 4 Release Candidate


3.5.8078 


SQL Server Compact 3.5 SP2 


1. Visual Studio 2010 and .NET Framework 4 RTM


2. SQL Server Compact 3.5 SP2 for Windows Desktop


3.5.8080 


 


 


 


 


 


Update: This information is now available as a KB Article 950550.  The KB article list only the final release versions and not beta/CTP/alpha versions.


 


Thanks,


Laxmi Narsimha Rao ORUGANTI


 

Comments (10)

  1. ErikEJ says:

    Great to have this list available – very useful. How about adding version 3.0.5214 from SQL Server Mobile Edition 3.0 Device SDK download?

  2. Laxmi,

    The latest version I can find that’s available for download is Microsoft SQL Server Compact 3.5 and Microsoft Synchronization Services for ADO.Net v1.0 for Windows Desktop (v.3.5.5386.0).

    What’s the availability and download point for SQL Server Compact 3.5 SP1 Beta for ADO.NET Entity Framework Provider Beta (v.3.5.5626)?

    Thanks in advance,

    –rj

    See http://oakleafblog.blogspot.com/2008/02/linq-and-entity-framework-posts-for.html

  3. Jared says:

    Thanks for this update!

    Do you have any more info on the changes (features, performance, bugs, etc) that are in all these different version of SQLCE?  Or, do these different versions just address interop/connectivity/compatibility issues with different release vehicles?

    Thanks again

  4. Henrik Bach says:

    How can I at runtime get the version number of the SQL Server Compact engine my app is using?

  5. Juan Foegen says:

    It would be nice if a date column was also added to the release table.

  6. Daniel Smith says:

    Does anyone know when they will release 3.5SP1 for the SSCE Mobile rather than Desktop?  

  7. olnrao says:

    Daniel Smith,

    v3.5 SP1 for Devices would release along with v3.5 SP1 Desktop but may be thru different release channels.  

    Juan Foegen,

    Thanks for the feedback.  I would incorporate your feedback when I get full information on the exact public release dates of different milestones.  Right now, on top of my head I dont remember them all.

    Henrik Bach,

    You could use SqlCeConnection.ServerVersion to get the runtime/server version.  You could also use FileVersionInfo.GetVersionInfo .NET API on any of our DLLs to know the version.

    Thanks,

    Laxmi

  8. Derek's Blog says:

    The lengths I go to when performing Visual Studio updates only seem odd to the uninitiated. I’ve been

  9. I have several posts queued to talk about the architecture and building blocks behind the 2008 Windows

  10. Como referi em posts anteriores, tenho estado de volta do upgrade de uma aplicação para .NET CF 3.5 e