How to install a SQL CE data base on a windows mobile device

From TechnologicalWiki

This article doesn't belong to any category. Each article must belong at least some the next categories : - OpenSource - HowTo - Mobile - Project - ProjectSection - UnifiedCommunications - OSAmI - Please add a valid category to the end of the article.

[edit] Introduction

Microsoft SQL Server Compact (SQL CE) is a compact relational database produced by Microsoft for applications that run on mobile devices and desktops.

SQLCE has similar characteristics as SQL data bases but the main difference is its small size, due to the fact this DDBB is installed on little devices like phones or PDAs. One of the main differences is that there is only one users of the same data base and if there are more than one, developers have to control it on the application.

There are multiple versions of SQL CE, but the last one is SQL Server Compact 3.5 SP1 supporting .NET Framework 3.5 which is compatible with Windows Mobile 2003, 5.0 and 6.0.

[edit] Download

We can get SQL CE files on Microsoft web, concretly on http://www.microsoft.com/downloads/details.aspx?FamilyId=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en

Here we can find CAB files for installing SQL Server 2005 Compact on mobile devices, MSI file for installing SQL Server 2005 Compact Edition on desktop and tablet PC, header files required for developing a native SQL Server Compact application, MSI for installing the SQL Server 2005 Compact Edition Help Files and Northwind sample application.

I thank you humlby for sharing your wisdom JJWY