I'd like to use SQL Server CE in my application but it's not installed on my device, what are the steps to get it working?
SQL Server for CE is not included in our evaluation images due to it's size (~2MB) but it can easily be installed manually or through an automated program (like ADSCopy).
You can get the SQL Server CE redistributable package either as a direct download from Microsoft or if you have Visual Studio 2003 installed, it is on your development PC. By default it is found in the following directory:
C:\Program Files\Microsoft Visual Studio .NET 2003\CompactFrameworkSDK\v1.0.5000\Windows CE\wce400\armv4t
I manually installed the three cab files mentioned above. I can use sqlce, but it goes away after I power down. I don't have battery backup. Is there a way to have the sqlce files installed such that I don't have to have battery backup??
Sure. Use the ADSCopy code that Chris put together (topic 1364, linked above). It re-installs the server after a cold boot. ADSCopy and the installation files reside on the non-volatile FlashFX disk.