SQL ServerSQL Server 2005 Mobile Edition is the successor to Microsoft SQL Server Windows CE Edition (SQL Server CE) version 2.0. Both versions are powerful tools that make it easy to develop mobile applications by supporting familiar Structured Query Language (SQL) syntax and by providing a development model and API consistent with SQL Server. The database engine exposes an essential set of relational database features, such as an optimizing query processor and support for transactions and assorted data types, while maintaining a compact footprint that preserves precious system resources. Remote data access and merge replication ensure that data from SQL Server databases is delivered reliably; can be manipulated offline; and can be synchronized later to the server, making SQL Server Mobile and SQL Server CE ideal for mobile and wireless environments. Both versions are designed to integrate with the .NET Compact Framework through Visual Studio, simplifying database application development for devices. By using the SQL Server CE or SQL Server Mobile Edition data provider to manage code by means of the common language runtime, mobile application developers can build highly extensible applications with offline data management capability for disconnected scenarios. You should use SQL Server CE or SQL Server Mobile Edition as a complement to your development tools when:
|