SQL Server CE Basic overview

SQL Server The Edition compact (SQL Server Edition abbreviated to SQL Server CE later in this article) is a streamlined database product for embedded to mobile applications, Windows Mobile developers can use SQL Server CE to develop applications that extend data management capabilities to Windows Mobile mobile devices. Although SQL Server CE takes up only 3 to 5 megabytes of disk space, its functionality does not shrink as dramatically as its capacity. SQL Server CE not only provides complete SQL syntax, including internal joins, external joins and subqueries, but also includes support for data synchronization technologies. One thing to note is that the SQL Server Compact Edition, in addition to being able to run as a mobile database on a Windows Mobile device, also supports storing data on PCs and providing data support for desktop applications.

The following are some of the key features of the SQL Server Edition Compact:

• A streamlined database engine and a powerful query optimizer.

• Support for merge replication and remote data access (RDA).

· The SQL Server Compact Edition is fully integrated with SQL Server Management Studio and Visual Studio 2005. With SQL Server Management Studio, you can visually create a series of operations such as the SQL Server Compact Edition database, view database objects, create tables, modify tables, and perform interactive queries.

• Remote data access and merge replication for synchronizing data.

·. NET Framework and the. NET Compact Framework Data Access Interface (SYSTEM.DATA.SQLSERVERCE) for the SQL Server Compact Edition.

• Supports ado.net and OLE DB providers for the SQL Server Compact Edition.

· A subset of the SQL syntax.

• Deploy as an embedded database on desktops, mobile devices, and Tablet PCs.

• Support for ClickOnce deployment technology.