A familiar database platform for rapid development. The SQL Server products provide data management support and programmability across the enterprise from the largest servers to desktop workstations. It exposes a programming and operational model consistent with the rest, thereby ensuring that organizations can easily integrate with existing systems and take advantage of existing development skills. A compact yet capable relational database. Though devices are advancing rapidly, system resources like available memory are often scarce, so it is critical that a relational database system be as compact as possible while still exposing essential functionality.
Performance is enhanced with an optimizing query processor.
A range of data types is supported to ensure flexibility, and 128-bit encryption is provided on the device for database file security. Flexible data access. Allowing straightforward, efficient access to enterprise data is a primary goal for SQL Server CE, whether a device is always connected or intermittently connected. Remote data access exposes data in SQL Server version 6.5, SQL Server version 7.0, and SQL Server 2000 through remote execution of SQL statements and the ability to pull record sets to the client device for updating. When used with SQL Server 2000, it provides extended capabilities for synchronization through merge replication.