SQL Server CE 3.5 is the supported version of the database in VS2008. What that means is the designers like Server Explorer only work if the database is SSCE v3.5 (Note: I am talking about SSCE accessed by Server Explorer. Server Explorer can talk to other databases).
If need be you when migrating you will have to upgrade older file formats. To accomplish this use the SqlCEEngine upgrade method.
SqlCeEngineengine = new SqlCeEngine(srcConnection)
engine.Upgrade(destConnection);
If you specify encryption in the destination connection, the database file will be encrypted. One of the new features for 3.5 is updated encryption support. This includes support for more than just 3DES. SSCE 3.5 can now use AES 128 encryption. The only potential problem is that CE4.2 and Pocket 2003 based devices do not support AES 128. So if you need to be able to access a database on old and new devices you will have to enable compatibility mode which uses 3DES.
Additional SQL has been updated to support
- nested SELECT allows for doing some nested queries
- CROSS APPLY and OUTER APPLY which allows for using functions in a join like fashion
- CAST which allows for casting one data type to another
- TOP which allows selecting the first N rows
- SET IDENTITY INSERT which allows for specifying the actual identity value rather than auto incrementing
SSCE still does have a size limitation of 4 gigabytes. However over all the SQL Server CE team continues to push the envelope with what is possible.
Comments