Is it possible to upgrade a SQL CE 3.1 database to 3.5 in Windows CE 5.0? I
see that SqlCeEngine has a method called Upgrade, but every time I call it it
throws an exception with this error message:
The specified module could not be found
I was thinking this would be because it can't find some file(s), but I have
both SQL 3.1 and 3.5 installed on the device. Thanks for any help you can
give me on this.
PS I tried to upgrade the .sdf file from the device on the desktop, and it
works fine, so it isn't my .sdf file.
Bryan - 30 Apr 2008 22:40 GMT
I figured this out myself, but for the record I would like to share this with
everyone out there. I was not completly deploying the 3.5 runtime to the
device. There are 3 cab files that need to be installed for this to work.
They are all located at (by default):
C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Devices\wce500\x86
Obviously replace x86 with your processor type if it is different.
> Is it possible to upgrade a SQL CE 3.1 database to 3.5 in Windows CE 5.0? I
> see that SqlCeEngine has a method called Upgrade, but every time I call it it
[quoted text clipped - 8 lines]
> PS I tried to upgrade the .sdf file from the device on the desktop, and it
> works fine, so it isn't my .sdf file.