A familiar database platform for rapid development. The SQL Server family provides data management support and programmability across the enterprise from the largest servers to desktop workstations. SQL Server CE exposes a programming and operational model consistent with the rest of the SQL Server family, 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 such as 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 6.5, SQL Server 7.0, and SQL Server 2000 through remote execution of Transact-SQL statements and the ability to pull record sets to the client device for updating. When used with SQL Server 2000, SQL Server CE provides extended capabilities for synchronization through merge replication.