Hello!
Which is the version of SQL Server CE installed on Windows Mobile 6? I think is SQL Server 2005 Mobile Versión 3.0.
If I use a database of this version (3.0), will it work on version 3.1 and 3.5?
Thank you!
A:
In order to use a 3.1 database file with the 3.5 database engine it will need to be upgraded. If you attempt to open it in Visual Studio 2008 (which uses SQL CE 3.5) it will prompt you to do this. It can also be done programatically via the SqlCeEngine.Upgrade method.
The best table I could find regarding which version you may expect to find in ROM is the Device Capabilities and Required Development Tools document on MSDN, in particular the section headed "Database Technology Support" near the bottom.
Christopher Fairbairn
2009-10-28 21:41:40