Microsoft® SQL Server™ 2000 Windows® CE Edition 2.0 (SQL Server CE) extends the functionality of Microsoft SQL Server 2000 to the small footprint of Windows CE-based devices. This release of SQL Server CE provides enhanced database engine and query capabilities, improved connectivity solutions, and integration with the Microsoft Visual Studio® .NET development environment and the .NET Compact Framework.
SQL Server CE Books Online describes these enhancements in new sections and a redesigned content structure. In addition, the documentation has expanded to include more information and examples in the topics that cover connectivity, OLE DB, error handling, and SQL Server CE error messages.
SQL Server CE Database Engine
SQL Server CE Query Analyzer
SQL Server CE Query Analyzer now includes an easy-to-use interface that allows you to manage database objects in a graphical Objects tab. SQL Server CE Query Analyzer also provides 10 preset buttons in which you can save frequently used SQL statements for future querying.
For more information, see Using SQL Server CE Query Analyzer.
Additional intrinsic functions and support for the UNION operator allow you to create richer queries for accessing mobile data. For more information, see SQL Reference for SQL Server CE.
In conjunction with Microsoft ADO.NET, you also can use parameterized queries, which will result in faster querying and cleaner code. For more information, see Using Parameters in Queries.
SQL Server CE now supports 249 indexes per table, the same number of indexes per table as Microsoft SQL Server 2000. For more information, see Understanding SQL Server CE Database Objects.
A new error messages file (Ssceerror20en.dll) is available for application developers. For more information, see Installing SQL Server CE on a Windows CE-based Device.
SQL Server CE Connectivity
Two new connectivity tools allow you to configure the appropriate security and connectivity options:
- Use the SQL Server CE Connectivity Management utility to launch the SQL Server CE Virtual Directory Creation Wizard, manage existing Microsoft Internet Information Services (IIS) virtual directories, and set up additional NTFS permissions.
- Use the SQL Server CE Virtual Directory Creation Wizard to create new virtual directories and set up appropriate NTFS permissions.
For more information, see Using Connectivity Tools.
Replication and Remote Data Access (RDA)
The new UPLOAD replication option can significantly improve synchronization time when no changes need to be sent to the device. For more information, see ExchangeType Property (Replication).
To improve query performance, RDA now offers the ability to pull additional indexes from SQL Server. For more information, see Pull Method.
Development in Visual Studio .NET
Note This feature has been designed to be used in conjunction with a prerelease version of an anticipated successor to Microsoft Visual Studio .NET. Check the documentation accompanying the commercially released version for any updates.
.NET Compact Framework Data Providers
The System.Data.SqlServerCe namespace provides programmatic access to databases in SQL Server CE from a Visual Studio .NET application running on Windows CE .NET-based devices. For more information, see Data Provider for SQL Server CE (SqlServerCe).
The System.Data.SqlClient namespace provides the classes for developing Windows CE .NET-based applications that access databases in Microsoft SQL Server 7.0 or later. For more information, see Data Provider for SQL Server (SqlClient).
The IBuySpy Delivery sample application is a robust application based upon real-world scenarios. Use this application to learn how to write replication and RDA in the .NET Framework development environment. For more information, see IBuySpy Delivery .NET Framework Application.
An improved query optimizer uses all available indexes in processing DML statements, complex joins, outer joins, and predicates with ORDER BY clauses.
SQL Server CE server-side components provide better processing of large synchronizations and reduce overall CPU utilization on the computer running Microsoft Internet Information Services (IIS).
The SQL Server CE Client Agent supports a useful connectivity retry time-out default while still maintaining recoverability from lost connections in the field. For more information, see "Supported Connectivity Solutions," in Client and Server Environments.