Installing SQL Server Compact Edition on Wondows based Mobile device

Yesterday, i had some fun playing with SQL Server compact edition and installing it to my windows based mobile deivce, simple steps required to perform are:


1) Download SQL Server Compact Edition
http://www.microsoft.com/downloads/details.aspx?familyid=85e0c3ce-3fa1-453a-8ce9-af6ca20946c3&displaylang=en


2) Install it to your machine (Simple Installation Process)

3) Once it is installed, you are required to copy a three cab files to your mobile and install them (Engine & Query Analyzer)

http://msdn.microsoft.com/en-us/library/ms171875.aspx
http://www.christec.co.nz/blog/archives/253
http://msdn.microsoft.com/en-us/library/ms172361.aspx
http://msdn.microsoft.com/en-us/library/ms171773.aspx

4) To connect your mobile device to your PC you need ActiveSync software
http://www.microsoft.com/windowsmobile/en-us/help/synchronize/device-synch.mspx

5) On every step do visit the link posted under it.. Good Luck :)


Play with Query Analyzer on your machine, Connect your compact edition from SQL Server Management, BI and Visual Studio environments...
http://www.devx.com/MicrosoftISV/Article/34341