SQL Server 2000 and Windows CE

Microsoft® SQL Server 2000™ Windows® CE Edition provides a robust relational database engine for Windows CE devices:

• Optimized for Windows CE

  Microsoft® SQL Server 2000™ Windows CE Edition (SQL Server CE) is designed to run efficiently on typical Windows CE devices. The memory footprint for SQL Server CE is approximately 1 MB. SQL Server CE was designed from the ground up to balance size, RDBMS functionality, connectivity and performance.

  SQL Server CE is implemented as a set of dynamic-link libraries (DLLs) that operate as an OLE DB CE provider. This allows SQL Server CE to support the ADOCE and OLE DB CE APIs, and also means that multiple applications running at the same time can share a common set of DLLs, thereby saving space.

• Integrated Development Environment

  SQL Server 2000 CE is tightly integrated with the Windows CE development environment in a way that leverages the existing skills of SQL Server developers. SQL Server CE supports the ADOCE and OLE DB CE data access APIs in the Windows CE-based versions of Microsoft® Visual Basic™ and Visual C++™. The SQL language and data access APIs used by SQL Server CE applications are generally upwardly compatible with SQL Server applications. Programmers already used to developing SQL Server applications using ADO or OLE DB in other Windows environments can rapidly develop data-aware Windows CE applications using SQL Server CE.

• SQL Server 2000 Interoperability

  SQL Server CE can exchange data with instances of SQL Server 2000 running on other Windows platforms, giving Windows CE applications access to centrally located data. SQL Server CE supports a wide range of connectivity options to match the connectivity needs of different devices. SQL Server CE can operate as an anonymous merge replication subscriber to publications from instances of SQL Server 2000 running on other Windows platforms. This allows mobile disconnected users who must work autonomously to download data from a central database, work offline, and merge their work back into the central database. Devices that remain connected to the network can use the Remote Data Access feature to:

  • Connect to instances of SQL Server on other Windows platforms.
    
    
  • Execute a SQL statement and pull in the result set as a recordset.
    
    
  • Optionally, modify the recordset and push the modifications back to the instance of SQL Server on the other Windows platform.

  The SQL Server CE connectivity options are tailored for use on wireless networks through networking features such as data compression and messaging to reduce data transmissions, and robust recovery from lost connections.