Working with Microsoft SQL Server was a dream for me, I don't know why I like this product not because I am an MVP but because I found the convinience to use, more user friendly and easy to understand. I started working from SQL Server 6.5 when Windows NT4. 0 was the Server platform of choice. Now today we have not only the version of SQL Server for desktop but for mobile devices as well. It was the time when I started working on version 6.5 and was dreaming that one day SQL Server will be the database of choice and, today its a reality. Imagine I am a "SQL Server geek" so how can I stop myself from using the mobile version. Plus one of the reasons to bring the HTC P4350 is to experience the SQL Server for Mobile Devices which in this case is SQL Server Mobile 2005.
Installing Microsoft SQL Server Mobile 2005 is farely easy. Just follow the steps and enjoy the FREE Database Engine on your mobile device.
Step1- Check for .Net Compact Framework [version 2.x.x.xxxx.xx], refer to my post on "Detecting .Net Framework on Windows Mobile 5.0"
Step2- Download "SQL Server 2005 Mobile Edition SDK" from here http://www.microsoft.com/sql/editions/sqlmobile/installsdk.mspx
Step3- Install the SQL Server and then Locate C:\Program Files\Microsoft SQL Server 2005 Mobile Edition\Device\Mobile\v3.0\wce500\armv4i directory
Step3- Copy the below mention files to your Windows directory on your mobile device using Active Sync,
sqlce30.dev.ENU.ppc.wce5.armv4i.CAB
sqlce30.ppc.wce5.armv4i.CAB
sqlce30.repl.ppc.wce5.armv4i.CAB
Active Sync could be downloaded from http://www.microsoft.com/windowsmobile/activesync/default.mspx
Step4- Run the files in the same sequence as mention
Step5- Goto Programs and look for "Query Analyzer".
Enjoy using SQL Server on your mobile device.
Bandagi!