SQL Server 2005 Compact VS Mobile edition?

[Guest]

whats the difference between SQL Compact edition and SQL mobile edition?

Thanks,

Ofer

 

[Guest]

There are quite a few differences. See if this link helps:
http://www.microsoft.com/sql/editions/sqlmobile/default.mspx

You will find one of the main differences, is SQL Server Mobile Edition does
not support stored procedures.

Simon.

 

[Ginny Caughey [MVP]]

Ofer,

SQL Server Compact Edition is just the new name for SQL Mobile. You can
think of it as just version 3.1. The main technical difference is that SQL
Mobile couldn't run on desktop computers other than dev machines and
TabletPCs, and that restriction has been removed for SSCE.

 

[Guest]

I beg your pardon, I just re-read your post (should open my eyes abit more).
I thought you were asking what the differences between the desktop SQL Server
and the new version 3.0 Mobile Edition was.

There are so many names for SQL Mobile. The version number is what is
important.

Simon.

 

[Andrew Grillage]

SQL Server Compact Edition is just the new name for SQL Mobile. You can
think of it as just version 3.1. The main technical difference is that SQL
Mobile couldn't run on desktop computers other than dev machines and
TabletPCs, and that restriction has been removed for SSCE.

So is the current SQL Mobile 3.0 sdf file format unchanged in this new
release?

 

[Ginny Caughey [MVP]]

Andrew,

Yes it is unchanged.