Mobile vs Compact - What changed?

What really changed from SQL Mobile to SQL Compact besides allowing the database to run on any desktop? Is there a document somewhere explaining the differences, I did not see anything?

I just changed my development machine over to SP1 and wondered what code I should be changing.

I am filling the database from my C++ Desktop app using ADO using the OLEDB provider Microsoft.SQLSERVER.MOBILE.OLEDB.3.0 and using System.Data.SqlServerCe in my C# mobile app. Is that OLE provider valid with the new version or should it be *.COMPACT.3.1?

I thought there was now suppose to be some sort of automatic compaction, but I did not notice any new properties.

I would appreciate any insight into the changes.

Thanks,

Juan Foegen

From my understanding, SQL Server Compact edition is an updated version to SQL Server Mobile Edition. You can use the compact edition not only on the mobile devices, but also on various devices like Tablet PC's, desktop computers etc. Also they are trying to include lot of sync features in the future releases, as you can see now they released Sync Services for ADO.NET CTP, the next new sync model like Merge Replication and RDA and in the next version release of SQL Server Compact Framework 3.5 they are trying to include all these features.

You can visit http://blogs.msdn.com/stevelasker/ for more information on these changes.

However, the namespace System.Data.SqlServerCE is going to be same for all the releases as it was same in both SQL Server CE and SQL Server Mobile.

Thanks

Ravi.

|||The OLEDB provider has not changed name, as the 3.1 release mainly concerns lifting the restrictions on supported platforms. For detailed information on the new features and fixes in 3.1 (or 3.0.5300.0) see this kb article: http://support.microsoft.com/Default.aspx?kbid=920700|||

Thanks for all your help and other replies on this forum.