difference between "SQL Mobile 2005" and "SQL Compact 2005"

Hello,

Could someone give me the difference between "Sql Mobile 2005" and "Sql Compact 2005".
At first I thought they were the same, that this was just something of the change in naming the server has had the last months.
My first guess was that Mobile would be the new one, but I have 'accidently' downloaded the Compact and what seems the System.data.SqlServerCE.dll is newer.

So is there a difference?
If yes, what are they.
If not, is the "compact" then the latest version and the name to be used (since on the site only "mobile" is mentioned).

Best regards,
Ike Casteleyn

"SQL Mobile" and "SQL CE" are different names for the same product. There's no "Sql Compact 2005".

There are:

SQL CE 1.0 << Nobody remembers that.

SQL CE 2.0 << Ships with VS 2003. Now obsolete, no desktop support.

SQL Mobile 2005 (AKA SQL CE 3.0) << Ships with VS 2005, limited desktop support.

SQL CE 3.1 << Incremental update from 3.0 - bug fixes and official desktop support.

SQL CE 3.5 << Will be shipped with VS Orcas

|||Hello Ilya,

Thanks for the info. The compact and mobile thing was actually the names of the sdk's that are available.
But I will make sure I'll use the 3.1 version

Thanks,
Ike
|||For detailed information about what's new in version 3.1 see this kb article: http://support.microsoft.com/Default.aspx?kbid=920700|||

The current version of Sql for Mobile Devices is SQL Compact 2005 which version number 3.1 if you want to try the beta is version 3.5. When you install the files say version 3.0 but don't get confuse.

Bye

|||Thanks for the info.

I'll stick to the 3.1 version for now since this one has full support on the desktop without vs2005 installed.
The 3.5 I look at later when it's out of beta.

Best regards,
Ike